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

Page 1888

background image

1836

Brocade Network Advisor SAN User Manual

53-1003154-01

Views

H

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,