I Views

TIME_SERIES_DATA_1_2HOUR.MEASURE_ID,

TIME_SERIES_DATA_1_2HOUR.TARGET_ID, TIME_SERIES_DATA_1_2HOUR.COLLECTOR_ID, TIME_SERIES_DATA_1_2HOUR.MEASURE_INDEX, TIME_SERIES_DATA_1_2HOUR.ME_ID, TIME_SERIES_DATA_1_2HOUR.VALUE, TIME_SERIES_DATA_1_2HOUR.SUM_VALUE

from TIME_SERIES_DATA_1_2HOUR) union all

select TIME_SERIES_DATA_1_1DAY.TIME_IN_SECONDS, TIME_SERIES_DATA_1_1DAY.TARGET_TYPE, TIME_SERIES_DATA_1_1DAY.MEASURE_ID, TIME_SERIES_DATA_1_1DAY.TARGET_ID, TIME_SERIES_DATA_1_1DAY.COLLECTOR_ID, TIME_SERIES_DATA_1_1DAY.MEASURE_INDEX, TIME_SERIES_DATA_1_1DAY.ME_ID, TIME_SERIES_DATA_1_1DAY.VALUE, TIME_SERIES_DATA_1_1DAY.SUM_VALUE

from TIME_SERIES_DATA_1_1DAY) union all

select * from TIME_SERIES_DATA_2) union all

select TIME_SERIES_DATA_2_30MIN.TIME_IN_SECONDS, TIME_SERIES_DATA_2_30MIN.TARGET_TYPE, TIME_SERIES_DATA_2_30MIN.MEASURE_ID, TIME_SERIES_DATA_2_30MIN.TARGET_ID, TIME_SERIES_DATA_2_30MIN.COLLECTOR_ID, TIME_SERIES_DATA_2_30MIN.MEASURE_INDEX, TIME_SERIES_DATA_2_30MIN.ME_ID, TIME_SERIES_DATA_2_30MIN.VALUE, TIME_SERIES_DATA_2_30MIN.SUM_VALUE

from TIME_SERIES_DATA_2_30MIN) union all

select TIME_SERIES_DATA_2_2HOUR.TIME_IN_SECONDS, TIME_SERIES_DATA_2_2HOUR.TARGET_TYPE, TIME_SERIES_DATA_2_2HOUR.MEASURE_ID, TIME_SERIES_DATA_2_2HOUR.TARGET_ID, TIME_SERIES_DATA_2_2HOUR.COLLECTOR_ID, TIME_SERIES_DATA_2_2HOUR.MEASURE_INDEX, TIME_SERIES_DATA_2_2HOUR.ME_ID, TIME_SERIES_DATA_2_2HOUR.VALUE, TIME_SERIES_DATA_2_2HOUR.SUM_VALUE

from TIME_SERIES_DATA_2_2HOUR) union all

select TIME_SERIES_DATA_2_1DAY.TIME_IN_SECONDS, TIME_SERIES_DATA_2_1DAY.TARGET_TYPE, TIME_SERIES_DATA_2_1DAY.MEASURE_ID, TIME_SERIES_DATA_2_1DAY.TARGET_ID, TIME_SERIES_DATA_2_1DAY.COLLECTOR_ID, TIME_SERIES_DATA_2_1DAY.MEASURE_INDEX, TIME_SERIES_DATA_2_1DAY.ME_ID, TIME_SERIES_DATA_2_1DAY.VALUE, TIME_SERIES_DATA_2_1DAY.SUM_VALUE

from TIME_SERIES_DATA_2_1DAY

TIME_SERIES_DATA_VIEW

create or replace view TIME_SERIES_DATA_VIEW as

1656

Brocade Network Advisor IP User Manual

 

53-1003056-01

Page 1708
Image 1708
Brocade Communications Systems IP250 user manual Timeseriesdataview, TIMESERIESDATA12HOUR.MEASUREID