Brocade Communications Systems IP250 user manual Sflowiprouteinfo, Sflowminutebgp

I Database tables and fields

TABLE 345 SFLOW_HOUR_SUMMARY

Field	Definition		Format	Size
IN_PORT_TYPE	This column is used to store the port type of the		smallint
	incoming traffic interface. For VCS switch the value of
	•	0 means its edge port.
	•	1 means its trill port.

For other devices Default value is 0.

OUT_PORT_TYPE	This column is used to store the port type of the		smallint
	outgoing traffic interface. For VCS switch the value of
	•	0 means its edge port.
	•	1 means its trill port.

For other devices Default value is 0.

TABLE 346 SFLOW_IP_ROUTE_INFO

Field	Definition	Format	Size
SFLOW_IP_ROUTE_INFO_ID	This column is the primary key for IP routing	int
	information.
LOCAL_PREF	Local preference value of routing information in the	int
	received sFlow packet.
LAST_USED_TIME	Last used time of the routing information.	int
DST_AS_PATH	Routing path information in the received sFlow	varchar	2048
	packet.
COMMUNITIES	Communities value in the received sFlow packet.	varchar	1024

TABLE 347 SFLOW_MINUTE_BGP

Field	Definition	Format	Size
SLNUM	This column is used to store a counter value to	bigserial
	identify the total row count.
TIME_IN_SECONDS	Data collection time in seconds.	int
DEVICE_ID	ID of the product which sends the sflow traffic.	int
SRC_AS	Source AS number of the received sFlow packet in	bigint
	case of BGP traffic.
SFLOW_IP_ROUTE_INFO_ID	route_info_id of the received sFlow packet in case of	int
	BGP traffic.
IN_VLAN	Vlan ID of the incoming traffic interface.	smallint
OUT_VLAN	Vlan ID of the outgoing traffic interface.	smallint
FRAMES	Number of frames transmitted through the sflow	bigint
	sample collected.
BYTES	Number of bytes transmitted through the sflow	bigint
	sample collected.

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