Brocade Communications Systems IP250 user manual TEPORTSTATS2HOURINFO, TEPORTSTATS1DAYINFO

Views I

from TIME_SERIES_DATA_1_30MIN, VIRTUAL_SWITCH

where ME_ID = MANAGED_ELEMENT_ID and COLLECTOR_ID = 12

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

TE_PORT_STATS_2HOUR_INFO

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

ME_ID,
TARGET_ID as PORT_ID,
timestamp with time zone		'epoch' +		TIME_IN_SECONDS *	interval '1 second' as
CREATION_TIME,
sum(case when	MEASURE_ID	= 193 then value else 0 end) as
RECEIVE_OK_PERCENT_UTIL,
sum(case when	MEASURE_ID	= 194 then value else 0 end) as
TRANSMIT_OK_PERCENT_UTIL,
sum(case when	MEASURE_ID	= 196 then value else 0 end) as RECEIVE_OK,
sum(case when	MEASURE_ID	= 195 then value else 0 end) as TRANSMIT_OK,
sum(case when	MEASURE_ID	= 36 then		value else 0 end)	as RECEIVE_EOF,
sum(case when	MEASURE_ID	= 40 then		value else 0 end)	as UNDERFLOW_ERRORS,
sum(case when	MEASURE_ID	= 41 then		value else 0 end)	as OVERFLOW_ERRORS,
sum(case when	MEASURE_ID	= 43	then	value else 0 end)	as ALIGNMENT_ERRORS,
sum(case when	MEASURE_ID	= 42	then	value else 0 end)	as RUNT_ERRORS,
sum(case when	MEASURE_ID	= 43	then	value else 0 end)	as TOO_LONG_ERRORS,
sum(case when	MEASURE_ID	= 39	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 = 12

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

TE_PORT_STATS_1DAY_INFO

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

ME_ID,
TARGET_ID as PORT_ID,
timestamp with time zone		'epoch' +		TIME_IN_SECONDS *	interval '1 second' as
CREATION_TIME,
sum(case when	MEASURE_ID	= 193 then value else 0 end) as
RECEIVE_OK_PERCENT_UTIL,
sum(case when	MEASURE_ID	= 194 then value else 0 end) as
TRANSMIT_OK_PERCENT_UTIL,
sum(case when	MEASURE_ID	= 196 then value else 0 end) as RECEIVE_OK,
sum(case when	MEASURE_ID	= 195 then value else 0 end) as TRANSMIT_OK,
sum(case when	MEASURE_ID	= 36	then	value else 0 end)	as RECEIVE_EOF,
sum(case when	MEASURE_ID	= 40	then	value else 0 end)	as UNDERFLOW_ERRORS,
sum(case when	MEASURE_ID	= 41	then	value else 0 end)	as OVERFLOW_ERRORS,
sum(case when	MEASURE_ID	= 43	then	value else 0 end)	as ALIGNMENT_ERRORS,
sum(case when	MEASURE_ID	= 42	then	value else 0 end)	as RUNT_ERRORS,
sum(case when	MEASURE_ID	= 43	then	value else 0 end)	as TOO_LONG_ERRORS,
sum(case when	MEASURE_ID	= 39	then	value else 0 end)	as CRC_ERRORS
from TIME_SERIES_DATA_1_1DAY,			VIRTUAL_SWITCH
where ME_ID =	MANAGED_ELEMENT_ID and COLLECTOR_ID = 12

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

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