Brocade Network Advisor SAN User Manual v12.3.0 User Manual

Page 1609

Advertising
background image

Brocade Network Advisor SAN User Manual

1557

53-1003154-01

Database tables and fields

H

VCS_ID

This column is used to store the VCS ID of the
device. The value will be populated by the
NosSwitchAssetCollector during the discovery of
the VCS Cluster. The non zero value will be
stored as VCS ID. Default value is -1.

smallint

VCS_LICENSED

Indicates whether the cluster device has VCS
license or not. Possible values are 0 for not
applicable, 1 for licensed, 2 for not licensed. 0 is
default. Clusters with 2 or less nodes will have
value of 0 as all those clusters are automatically
licensed. Clusters with 3 or more nodes will have
values 1 or 2 depending on whether the license
was acquired or not.

RBRIDGE_ID

This column is used to store the Rbridge ID of
the device. The value will be populated by the
NosSwitchAssetCollector during the discovery of
the VCS member. The non zero value will be
stored as Rbridge ID. Default value is -1.

smallint

IS_PRINCIPAL_SWITCH

This column is used to determine whether VCS
member is a Principal switch or not. Value 1
indicates that this is a principal switch and 0
indicates that this not a Principal switch. The
values will be populated by the VCS collector
during the discovery of the VCS switch. The
default value of 0 means that its a principal
switch.

smallint

IS_NETCONF_REACHABLE

This column is used to determine whether the
device is netconf reachable. The value will be
populated by the NosSwitchAssetCollector. The
value of 0 means not reachable, 1 means
reachable port and -1 means unknown status.
Default value is -1

smallint

FABRIC_WATCH_STATUS

Switch status based on components.

smallint

FABRIC_WATCH_STATUS_REASON

Component reason for switch status.

varchar

1028

MAC_ADDRESS

The mac address to identify the wireless
controller or AP. This will be empty string for all
other devices.

varchar

64

MANAGED_AP_COUNT

Its the number of APs that the controller
managed.

int

CONTROLLER_CLUSTER_MODE

Cluster mode of the controller: Active, Standby
and None.
-1 : NA, 0 : None, 1 : Active, 2 : Standby.

int

CONTROLLER_CLUSTER_NAME

This is controller cluster name.

varchar

65

CONTROLLER_CLUSTER_PEER_IP IP addresses of the controller cluster peer.

varchar

128

WIRELESS_TYPE

To filter the APs from the product.
0 : NonAP, 1 : managed Brocade branded AP, 2 :
standalone Brocade branded AP.

int

BRIEF_PRODUCT_FAMILY

Shorter name for the product family.

varchar

32

TABLE 94

DEVICE (Continued)

Field

Definition

Format

Size

Advertising