Brocade Network Advisor 12.1.X Documentation Updates (53-1003016-05, January 2014)

1362 Brocade Network Advisor SAN User Manual
53-1002948-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
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 Management Cluster. States can be
Online, Offline, Rejoining etc.. For all other
devices this column will be empty.
varchar 64
TABLE 150 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
TABLE 149 DEVICE (Continued)
Field Definition Format Size