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

1290 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
TABLE 304 SFLOW_MINUTE_VLAN_SLNUM
Field Definition Format Size
MAX_SLNUM Maximum row count. bigint
TABLE 305 SFLOW_REPORT_L3_SOURCE
Field Definition Format Size
SFLOW_REPORT_L3_SOURCE_ID Primary key autogenerated ID. int
REPORT_DEFINITION_ID Report definition ID. int
ADDRESS_GROUP_ID ACL network group IDs mapped with a report
definition.
int
IP_SUBNET_DEFINITION_ID Subnet IDs mapped with a Report definition. int
TABLE 306 SFLOW_REPORT_L4_SOURCE
Field Definition Format Size
SFLOW_REPORT_L4_SOURCE_ID Primary key autogenerated ID. int
REPORT_DEFINITION_ID Report definition ID. int
SERVICE_PORT_DEFINITION_ID Service port Id mapped with a report definition. int
SERVICE_GROUP_ID Service group Id mapped with a report definition. int
TABLE 307 SFLOW_STAGING
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
IN_UNIT Unit number of the incoming traffic interface. Default
value is 0.
smallint
IN_SLOT Slot number of the incoming traffic interface. smallint
IN_PORT Port number of the incoming traffic interface. smallint
OUT_UNIT Unit number of the outgoing traffic interface. Default
value is 0.
smallint
OUT_SLOT Slot number of the outgoing traffic interface. smallint
OUT_PORT Port number of the outgoing traffic interface. smallint
IN_VLAN Vlan ID of the incoming traffic interface. smallint
OUT_VLAN Vlan ID of the outgoing traffic interface. smallint
IN_PRIORITY Priority ID of the incoming traffic interface. smallint
OUT_PRIORITY Priority ID of the outgoing traffic interface. smallint
SRC_MAC MAC address of the source in the received sFlow
packet.
bytea
DEST_MAC MAC address of the destination in the received sFlow
packet.
bytea