Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

Table Of Contents
Brocade Network Advisor SAN User Manual 1337
53-1002948-01
Database tables and fields
H
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 112 CLIENT_VIEW
Field Definition Format Size
ID * Unique generated database identifier. int
USER_NAME The Management application user name. varchar 128
NAME Client view name. varchar 255
DESCRIPTION Client View description. varchar 255
TABLE 113 CLIENT_VIEW_COLUMN
Field Definition Format Size
ID * Unique generated database identifier. int
NAME Name of the column. It is used as column header in
product list and property name in property sheet(SAN
and IP)
varchar 255
TABLE 111 CEE_PORT (Continued)
Field Definition Format Size