Brocade Communications Systems IP250 user manual EEMONITORSTATS5MININFO, EEMONITORSTATS30MININFO

Views I

EE_MONITOR_STATS_5MIN_INFO

create or replace view EE_MONITOR_STATS_5MIN_INFO as select VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID,

ME_ID,

TARGET_ID as EE_MONITOR_ID,

timestamp with time zone 'epoch' + TIME_IN_SECONDS * interval '1 second' as

CREATION_TIME,

sum(case when MEASURE_ID = 208 then value else 0 end) as TX_UTILIZATION, sum(case when MEASURE_ID = 209 then value else 0 end) as RX_UTILIZATION, sum(case when MEASURE_ID = 210 then value else 0 end) as CRC_ERRORS from TIME_SERIES_DATA_1, VIRTUAL_SWITCH

where ME_ID = MANAGED_ELEMENT_ID and COLLECTOR_ID = 16

group by ME_ID, TARGET_TYPE, TARGET_ID, TIME_IN_SECONDS,VIRTUAL_SWITCH_ID order by TIME_IN_SECONDS desc;

EE_MONITOR_STATS_30MIN_INFO

create or replace view EE_MONITOR_STATS_30MIN_INFO as select VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID,

ME_ID,

TARGET_ID as EE_MONITOR_ID,

timestamp with time zone 'epoch' + TIME_IN_SECONDS * interval '1 second' as

CREATION_TIME,

sum(case when MEASURE_ID = 208 then value else 0 end) as TX_UTILIZATION, sum(case when MEASURE_ID = 209 then value else 0 end) as RX_UTILIZATION, sum(case when MEASURE_ID = 210 then value else 0 end) as CRC_ERRORS from TIME_SERIES_DATA_1_30MIN, VIRTUAL_SWITCH

where ME_ID = MANAGED_ELEMENT_ID and COLLECTOR_ID = 16

group by ME_ID, TARGET_TYPE, TARGET_ID, TIME_IN_SECONDS,VIRTUAL_SWITCH_ID order by TIME_IN_SECONDS desc;

EE_MONITOR_STATS_2HOUR_INFO

create or replace view EE_MONITOR_STATS_2HOUR_INFO as select VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID,

ME_ID,

TARGET_ID as EE_MONITOR_ID,

timestamp with time zone 'epoch' + TIME_IN_SECONDS * interval '1 second' as

CREATION_TIME,

sum(case when MEASURE_ID = 208 then value else 0 end) as TX_UTILIZATION, sum(case when MEASURE_ID = 209 then value else 0 end) as RX_UTILIZATION, sum(case when MEASURE_ID = 210 then value else 0 end) as CRC_ERRORS from TIME_SERIES_DATA_1_2HOUR, VIRTUAL_SWITCH

where ME_ID = MANAGED_ELEMENT_ID and COLLECTOR_ID = 16

group by ME_ID, TARGET_TYPE, TARGET_ID, TIME_IN_SECONDS,VIRTUAL_SWITCH_ID order by TIME_IN_SECONDS desc;

EE_MONITOR_STATS_1DAY_INFO

create or replace view EE_MONITOR_STATS_1DAY_INFO as select VIRTUAL_SWITCH.ID as VIRTUAL_SWITCH_ID,

ME_ID,

TARGET_ID as EE_MONITOR_ID,

Brocade Network Advisor IP User Manual	1609
53-1003056-01