Brocade Network Advisor SAN User Manual v12.0.0 (53-1002696-01, April 2013)

Brocade Network Advisor SAN User Manual 1187
53-1002696-01
Database tables and fields
H
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 77 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
ICON Type of Icon. int
OS Operating System. varchar 256
APPLICATIONS Application which created device enclosure. varchar 256
DEPARTMENT Department using this device enclosure. varchar 256
CONTACT Contact person details. varchar 256
LOCATION Location of physical setup. varchar 256
TABLE 76 DEVICE (Continued)
Field Definition Format Size