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

Brocade Network Advisor SAN User Manual 1289
53-1002696-01
Database tables and fields
H
TABLE 302 SFLOW_MINUTE_SUMMARY
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
FRAMES Number of frames transmitted through the sflow
sample collected.
bigint
BYTES Number of bytes transmitted through the sflow
sample collected.
bigint
IN_PORT_TYPE Port type of the incoming traffic interface. For VCS
member the value of,
• 0 means its edge port
• 1 means its fabric port.
For other devices Default value is 0.
smallint
OUT_PORT_TYPE Port type of the outgoing traffic interface. For VCS
member the value of,
• 0 means its edge port
• 1 means its fabric port.
For other devices Default value is 0
smallint
TABLE 303 SFLOW_MINUTE_VLAN
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
FRAMES Number of frames transmitted through the sFlow
sample collected.
bigint
BYTES Number of bytes transmitted through the sFlow
sample collected.
bigint
IN_VLAN Vlan ID of the incoming traffic interface. smallint
OUT_VLAN Vlan ID of the outgoing traffic interface. smallint
IN_PORT_TYPE Port type of the incoming traffic interface. For VCS
member the value of,
• 0 means its edge port.
• 1 means its fabric port.
For other devices Default value is 0.
smallint
OUT_PORT_TYPE Port type of the outgoing traffic interface. For VCS
member the value of,
• 0 means its edge port.
• 1 means its fabric port.
For other devices Default value is 0.
smallint