Brocade Communications Systems IP250 user manual TEPORTSTATS5MININFO, TEPORTSTATS30MININFO

I Views

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_1DAY, 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;

TE_PORT_STATS_5MIN_INFO

create or replace view TE_PORT_STATS_5MIN_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,		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_30MIN_INFO

create or replace view TE_PORT_STATS_30MIN_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

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