Filter
Top Products
Brocade Network Advisor IP User Manual 1409
53-1003056-01
Database tables and fields
I
USER_DEFINED_VALUE_1 User defined value used for product. varchar 256
USER_DEFINED_VALUE_2 User defined value used for product. varchar 256
USER_DEFINED_VALUE_3 User defined value used for product. varchar 256
CLUSTER_MEMBER_STATE Indicates the state of the member in Fabric
Cluster and logical chassis. States can be
Online, Offline, Rejoining etc.. For all other
devices this column will be empty.
varchar 64
MODE Denotes the mode of the device. 1 denotes it is
in non-AG mode and 2 denotes that the device is
in AG mode.-1 denotes not applicable and will
be set to all non NOS devices.
int
TABLE 92 DEVICE_CONNECTION
Field Definition Format Size
ID The primary key. int
FABRIC_ID ID of the fabric which the device port is connected to.
It refers the ID column of FABRIC table.
int
DEVICE_PORT_ID ID of end device port. It refers ID field of
DEVICE_PORT table.
int
SWITCH_PORT_ID ID of switch port which end device port is connected.
In case device port is connected through AG, this port
refer the switch port which AG is connected. It refers
to the ID field of SWITCH_PORT table.
int
AG_PORT_ID In case of AG, this would refer to F Port of the AG
which end device port is connected. If the device port
is directly connected to switch port or NPIV
connection then it would be -1. It refers to the ID field
of SWITCH_PORT table for the access gateway
switches.
int
CREATION_TIME Time at which the device connection record is
created.
timestamp
LAST_UPDATED_TIME Time at which connection properties are modified for
this record.
timestamp
MISSING Indicates if the device connection is missing or not. int
MISSING_TIME Time from which the device connection has been
missing.
timestamp
TRUSTED Indicates if the device connection is trusted or not. int
TABLE 93 DEVICE_ENCLOSURE
Field Definition Format Size
ID* Unique generated database identifier. int
NAME Name of the Device enclosure. varchar 256
TYPE Type of Device enclosure - Storage Array/Server. varchar 32
TABLE 91 DEVICE (Continued)
Field Definition Format Size