User's Manual

Brocade Network Advisor IP User Manual 1415
53-1003056-01
Database tables and fields
I
MISSING Denotes if this device port is missing or not. smallint
MISSING_TIME Denotes the time from which the device port is
missing. Applicable only if the device is missing.
timestamp
NPV_PHYSICAL Denotes if this is physical device port or a logical
NPIV port.
smallint
EDGE_SWITCH_PORT_WWN EDGE_SWITCH_PORT_WWN will be the same as the
SWITCH_PORT_WWN except in the case of devices
behind the AG. This field will be updated by the
name server info collector, added for the feature
support of AG WWN N port mapping. This is a null
able field. It is used to determine which mapping is
used by the AG.
char 23
LOGGED_TO_AG Indicates if the device is connected with an AG. Not
null field and default value is 0, device not
connected to AG
smallint
AG_NODE_WWN If the device is connected with an AG, the AG switch
WWN will be populated. Not null field and default
value is empty
char 23
AG_N_PORT_WWN If the device is connected with an AG, N-Port WWN
of AG which is connected to switch will be populated
from the N2F and N2WWN map
char 23
MISSING_REASON The device missing reason. varchar 1024
TABLE 102 DEVICE_PORT_GIGE_PORT_LINK
Field Definition Format Size
DEVICE_PORT_ID The primary key of the DevicePort int
GIGE_PORT_ID The primary key of the GigEPort. int
DIRECT_ATTACH Indicates whether the device port is directly attached
to the CEE 10G TE port.
smallint
VIRTUAL_FCOE_PORT_ID The value of virtual_fcoe_port_id in the
Device_Port_Gige_Port_Link table is applicable only
for NOS devices. For FOS devices, the
virtual_fcoe_port_id value, will be null, as currently in
the Management application that mapping data is not
collected. Hence the default value is null.
int
LAG_ID LAG interface ID which associates port channel with
end device. This will be null if device port is associated
with physical gige port.
int
TABLE 103 DEVICE_PORT_MAC_ADDRESS_MAP
Field Definition Format Size
DEVICE_PORT_ID The primary key of the device port int
MAC_ADDRESS Mac address of the device varchar 64
TABLE 101 DEVICE_PORT
Field Definition Format Size