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

Brocade Network Advisor SAN User Manual 1207
53-1002696-01
Database tables and fields
H
TRUSTED 1 = the switch is a trusted member of the fabric. Either
found in the initial discovery or user subsequently
entrusted the switch by user action.
Default Value is 0.
smallint
CREATION_TIME When the switch became a member.
Default Value is ’now()’.
timestamp
MISSING 1 = it is missing from the fabric.
Default Value is 0.
smallint
MISSING_TIME When it is missed from the fabric; null if the member is
entrusted.
timestamp
LAST_UPDATE Last Updated time for the record. bigint
TABLE 112 FABRIC_THRESHOLD_SETTING
Field Definition Format Size
FABRIC_ID* References the ID in FABRIC table int
POLICY_ID* References the ID in THRESHOLD_POLICY table int
TABLE 113 FABRIC_VCS_CLUSTER_MAP
Field Definition Format Size
FABRIC_ID Foreign key to ID in fabric table. int
VCS_CLUSTER_ME_ID Foreign key to ID in ManagedElement table. This is
the VCS cluster entry managed_element_id
reference.
int
TABLE 114 FABRIC_ZONING_EDIT_RESTRICTION
Field Definition Format Size
ID Unique generated database identifier. int
FABRIC_ID PK of the owning fabric int
CHANGE_COUNT Count of the maximum changes allowed in active zone
config in the fabric.The default value is 0.
int
TABLE 115 FAVORITES
Field Definition Format Size
ID* Unique generated database identifier. int
NAME Name of the favorite. varchar 64
USER_ The application user credentials. varchar 128
TOP_N The top number of ports(5,10,15,20). varchar 40
SELECTION_FILTER Types of ports (FC/FCIP/GE) and -End Monitors. varchar 40
TABLE 111 FABRIC_MEMBER (Continued)
Field Definition Format Size