Brocade Communications Systems Network Advisor 12.3.0, User Manual

Page: 1610 / 1940

1558 Brocade Network Advisor SAN User Manual
53-1003154-01
Database tables and fields
H
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
USER_IP_ADDRESS 'This column is used to store the IP address
given by the user during discovery time. For
profile based discovery, we will populate the
seed switch IP address selected by the system. varchar 255
VCS_VF_ENABLED This represents where the device has VCS
virtual fabric support or not. The possible values
are -1,0 and 1. Default value -1 applicable for all
IOS device and NOS firmware version less than
4.1.The value 0 will be set if the device supports
VCS VF and its disabled. The value 1 will be set if
its enabled on the device. int
TABLE 95 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
TABLE 94 DEVICE (Continued)
Field Definition Format Size