Brocade Network Advisor SAN + IP User Manual v12.1.0 - Manual (Page 2207)

2170 Brocade Network Advisor SAN + IP User Manual
53-1002949-01
Database tables and fields
I
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
TABLE 383 SFLOW_MINUTE_L3_SLNUM
Field Definition Format Size
MAX_SLNUM Maximum row count. bigint
TABLE 384 SFLOW_MINUTE_MAC
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
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
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
L3_SRC_ADDR This column is used to store the L3 address of the
source in the received sFlow packet. bytea
L3_DEST_ADDR This column is used to store the L3 address of the
destination in the received sFlow packet. bytea
TABLE 385 SFLOW_MINUTE_MAC_SLNUM
Field Definition Format Size
MAX_SLNUM Maximum row count. bigint
TABLE 382 SFLOW_MINUTE_L3 (Continued)
Field Definition Format Size