Brocade Network Advisor IP User Manual v12.1.0 - Manual (Page 1543)

Brocade Network Advisor IP User Manual 1489
53-1002947-01
Database tables and fields
I
SUBNET_MASK varchar 40
PRIMARY_IP Indicates if the IP address is the primary IP address
of the Interface.
1 - Primary
0 - Secondary. smallint
TABLE 241 INTERFACE
Field Definition Format Size
INTERFACE_ID int
SWITCH_SERVICE_ID int
DEVICE_ID int
NAME varchar 255
IDENTIFIER varchar 255
TABLE_SUBTYPE varchar 255
TAG_MODE smallint
VLAN_TAG_TYPE int
UNTAGGED_VLAN_ID smallint
IF_NAME varchar 64
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 240 INM_IP_INTERFACE (Continued)
Field Definition Format Size