Time_series_data_info – Brocade Network Advisor SAN + IP User Manual v12.1.0 User Manual

Page 2337

background image

2300

Brocade Network Advisor SAN + IP User Manual

53-1002949-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,