User Manual v12.3.0 Owner's manual

Brocade Network Advisor IP User Manual 1551
53-1003153-01
Database tables and fields
I
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