Brocade Network Advisor IP User Manual v12.3.0 - Manual (Page 1575)

Brocade Network Advisor IP User Manual 1523
53-1003153-01
Database tables and fields
I
TABLE 50 CEE_PORT
Field Definition Format Size
ID Unique generated database identifier. int
GIGE_PORT_ID FK to GIGE_PORT int
VIRTUAL_SWITCH_ID FK to owning VIRTUAL_SWITCH int
IF_INDEX Interface index int
IF_NAME Interface name varchar 256
IF_MODE Gige port mode (L2, L3, none) varchar 8
L2_MODE L2 mode (hybrid, trunk, access) varchar 32
VLAN_ID List of VLAN this port belongs to text
LAG_ID LAG ID this port belongs to int
IP_ADDRESS Port''s configured IP address varchar 128
MAC_ADDRESS Port''s MAC address varchar 64
PORT_SPEED Speed in Gb/sec. The default value is 0. int
ENABLED State. The default value is 0. smallint
OCCUPIED The default value is 0. smallint
LAST_UPDATE bigint
MAC_ACL_POLICY stores the MAC ACL policy information of the port varchar 64
NET_MASK Netmask of the IPAddress of the port varchar 128
PROTOCOL_DOWN_REAS
ON Reason for the port''s operational state being down varchar 512
QOS_TYPE QoS Type (Cee-Map, TrafficClass Map, FCoE map) varchar 32
QOS_NAME Name of the QoS Map set on the port varchar 64
DOT1X_ENABLED Indicate if 802.1x authentication is enabled on this
port. The default value is 0. smallint
PORT_ROLE Thisfield is used to store the port role value. The value
will be populated by the NosSwitchAssetCollector. This
field valid values include ISL or Edge. Default value is
empty string. varchar 32
TABLE 51 CFG_BACKUP_ARCHIVE
Field Definition Format Size
CFG_BACKUP_ARCHIVE_ID int
DEVICE_ID IP Product DB ID from which the configuration has
been retrieved. int
USER_ID Unique DB ID of user who initiated this config
upoload. int
PRODUCT_TYPE Indicates the type of product from which the config is
retrieved for example NetIron XMR/MLX. varchar 32
VERSION Version of the configs downloaded for each product. num (8,0)
LOCATION varchar 255