Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

1286 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
FRAMES Number of frames transmitted through the sFlow
sample collected.
bigint
BYTES Number of bytes transmitted through the sFlow
sample collected.
bigint
TCP_FLAGS TCP flag value of the received sFlow packet. smallint
IN_PORT_TYPE This column is used to store the port type of the
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.
smallint
OUT_PORT_TYPE This column is used to store the port type of the
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.
smallint
TABLE 295 SFLOW_IP_ROUTE_INFO
Field Definition Format Size
SFLOW_IP_ROUTE_INFO_ID This column is the primary key for IP routing
information.
int
LOCAL_PREF Local preference value of routing information in the
received sFlow packet.
int
LAST_USED_TIME Last used time of the routing information. int
DST_AS_PATH Routing path information in the received sFlow
packet.
varchar 2048
COMMUNITIES Communities value in the received sFlow packet. varchar 1024
TABLE 296 SFLOW_MINUTE_BGP
Field Definition Format Size
SLNUM This column is used to store a counter value to
identify the total row count.
bigserial
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
case of BGP traffic.
bigint
SFLOW_IP_ROUTE_INFO_ID route_info_id of the received sFlow packet in case of
BGP traffic.
int
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
sample collected.
bigint
BYTES Number of bytes transmitted through the sflow
sample collected.
bigint
TABLE 294 SFLOW_HOUR_SUMMARY
Field Definition Format Size