Time_series_data_info – Brocade Network Advisor IP User Manual v12.3.0 User Manual

Page 1882

Advertising
background image

1830

Brocade Network Advisor IP User Manual

53-1003153-01

Views

I

TIME_SERIES_DATA_INFO

CREATE VIEW time_series_data_info AS

( ( ( ( ( (

select * from TIME_SERIES_DATA_1

union all

select TIME_SERIES_DATA_1_30MIN.TIME_IN_SECONDS,

TIME_SERIES_DATA_1_30MIN.TARGET_TYPE,

TIME_SERIES_DATA_1_30MIN.MEASURE_ID,

TIME_SERIES_DATA_1_30MIN.TARGET_ID,

TIME_SERIES_DATA_1_30MIN.COLLECTOR_ID,

TIME_SERIES_DATA_1_30MIN.MEASURE_INDEX,

TIME_SERIES_DATA_1_30MIN.ME_ID,

TIME_SERIES_DATA_1_30MIN.VALUE,

TIME_SERIES_DATA_1_30MIN.SUM_VALUE

from TIME_SERIES_DATA_1_30MIN)

union all

select TIME_SERIES_DATA_1_2HOUR.TIME_IN_SECONDS,

TIME_SERIES_DATA_1_2HOUR.TARGET_TYPE,

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,

Advertising
Popular Brands
Popular manuals