beautypg.com

Brocade Network Advisor SAN + IP User Manual v12.3.0 User Manual

Page 2488

background image

2416

Brocade Network Advisor SAN + IP User Manual

53-1003155-01

Database tables and fields

I

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 354

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 355

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 353

SFLOW_HOUR_SUMMARY

Field

Definition

Format

Size