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

1380 Brocade Network Advisor SAN User Manual
53-1002948-01
Database tables and fields
H
TABLE 177 FABRIC_CHECKSUM
Field Definition Format Size
FABRIC_ID * Fabric ID, foreign key to the FABRIC table. int
CHECKSUM_KEY * Type of checksum, e.g. device data or zone data. varchar 32
CHECKSUM Actual checksum value. varchar 16
TABLE 178 FABRIC_COLLECTION
Field Definition Format Size
FABRIC_ID * Fabric ID, foreign key to the FABRIC table. int
COLLECTOR_NAME * Name of the collector, e.g., NameServerInfoCollector,
TopologyCollector, ZoneInfoCollector,
ActiveZoneInfoCollector.
varchar 256
SEED_SWITCH_IP IP address of the switch which serves as the seed
switch. This is the switch from which above mentioned
fabric level collectors get their information.
varchar 128
LAST_SEED_SW_
MODIFICATION
Timestamp of the seed switch, when the particular
HTML page was changed last. Note that this is not
when the last time collection was done.
timestamp
TABLE 179 FABRIC_MEMBER
Field Definition Format Size
FABRIC_ID* Fabric ID, foreign key to FABRIC table. int
VIRTUAL_SWITCH_ID* ID of the virtual switch which is a member of this fabric,
foreign key to VIRTUAL_SWITCH table.
int
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 180 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