User's Manual

1462 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
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 183 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 184 IP_DEVICE_LICENSE
Field Definition Format Size
ID Primary Key field for the DEVICE_LICENSE int
DEVICE_ID This is the foreign key reference to the Device table int
HASH
A unique hash for identifying a license entry in the
device. This helps to traverse through the entries
with same package name and LID.
varchar 24
PACKAGE_NAME Name of the license package. Package defines the
features enabled by the license.
Example:SW-NI-CES-2024-L3U
varchar 64
LICENSE_ID License ID of the chassis or the line module for
which, this entry displays license
information.Example: fJucJFgFHG
varchar 24
TABLE 182 INTERFACE (Continued)
Field Definition Format Size