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

Table Of Contents
Brocade Network Advisor SAN User Manual 1409
53-1002948-01
Database tables and fields
H
LLDP_PORT_ID_SUBTYPE smallint
LLDP_PORT_ID bytea
IS_FDP_ENABLED num (1,0)
IS_CDP_ENABLED num (1,0)
PORT_STATUS smallint
PORT_STATE smallint
IF_INDEX This column is used to store the ifIndex of the
interface. The value will be populated by the DCB
collector during the discovery of the DCB switch.
Since this value is not populated by IP discovery
engine, making the field as nullable.
int
AMPP_PROFILE_MODE Specifies whether the interface is set to AMPP profile
mode.
smallint
DOT1D_PORT_NUM To store dot1d port number in DB to reduce SNMP
calls to switch from IfIndexUtility
int
EDGE_TYPE The type of the device that is connected to the edge
switch port.
-1 : NA, 0 : connected to device with unknown type, 1
: connected to managed Brocade branded AP, 2 :
connected to standalone Brocade branded AP.
int
USER_DEFINED_VALUE_1 User defined value used for IP Port. varchar 256
USER_DEFINED_VALUE_2 User defined value used for IP Port. varchar 256
USER_DEFINED_VALUE_3 User defined value used for IP Port. varchar 256
TABLE 227 INTERFACE_DEPLOYMENT_CONFIG
Field Definition Format Size
ID Unique generated database identifier. serial
DEPLOYMENT_ID Deployment configuration ID. Foreign Key for
DEPLOYMENT table.
int
CLEAR_CONFIGURATION 1/0 corresponding to ''Clear Assignment'' / ''Assign
Configuration'' for interface level configuration.
smallint
WRITE_TO_DEVICE 1/0 corresponding to Write to device/not write to
device for outbound traffic.
smallint
BINDING_DIRECTION Represents the binding direction. 0/1 corresponds to
IN / OUT direction.
smallint
TABLE 228 IP_INTERFACE
Field Definition Format Size
ID* Unique generated database identifier. int
ETHERNET_PORT_ID GigE Port ID. int
IP_ADDRESS IP address on the Ip_interface. varchar 64
TABLE 226 INTERFACE (Continued)
Field Definition Format Size