Brocade Network Advisor SAN User Manual v12.1.0 User Manual
Page 1414
Brocade Network Advisor SAN User Manual
1367
53-1002948-01
Database tables and fields
H
TABLE 89
DEVICE_PORT
Field
Definition
Format
Size
NODE_ID
Reference to the ID of the Device Node of which this
device port is a part of.
int
DOMAIN_ID
Stores the Domain ID of the switch to which this
device port is connected to.
int
WWN
Stores the Device Port WWN
char
23
SWITCH_PORT_WWN
Stores the switch port wwn to which this device port
is physically connected to. However If the device is
connected to an AG, this will contain the switch port
WWN till the AG impact is applied by the application.
If AG impact fails to be applied this will continue to
have the switch port wwn instead of the AG port
wwn.
char
23
NUMBER
Stores the port number of this device port.
smallint
PORT_ID
Stores the FDMI host name.
varchar
6
TYPE
Stores the Vendor of this device.
varchar
32
SYMBOLIC NAME
Stores the Symbolic Name.
varchar
256
FC4_TYPE
varchar
64
COS
Stores the Class of Service.
varchar
16
IP_PORT
varchar
63
HARDWARE_ADDRESS
Stores the Hardware Address.
varchar
32
TRUSTED
Denotes if the device port is trusted or not.
smallint
CREATION_TIME
The creation time of this record.
timestamp
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