Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1610

Advertising
background image

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

Advertising