HP Brocade 8/12c Brocade Network Advisor Documentation Updates v11.1.x (53-100 - Page 31

Database tables and fields E TABLE 17 Field FABRIC (Continued) Definition Format Size MANAGEMENT_STATE Bit map to indicate various management indications for smallint the fabric. TRACK_CHANGES 1 = changes (member switches, ISL and devices) in the smallint fabric are tracked. STATS_COLLECTION 1 = statistics collection is enabled on the fabric. smallint CREATION_TIME When the fabric record is inserted, i.e., created. timestamp LAST_FABRIC_CHANGED Time when fabric last changed. timestamp LAST_SCAN_TIME timestamp LAST_UPDATE_TIME Time when fabric was last updated. timestamp ACTIVE_ZONESET_NAME Name of the zone configuration which is effective / varchar 256 active in that fabric. USER_DEFINED_VALUE_ User-defined custom value. 1 varchar 256 USER_DEFINED_VALUE_ User-defined custom value. 2 varchar 256 USER_DEFINED_VALUE_ User-defined custom value. 3 varchar 256 Collector TABLE 18 Field FABRIC_CHECKSUM Definition FABRIC_ID * CHECKSUM_KEY * CHECKSUM Fabric ID, foreign key to the FABRIC table. Type of checksum, e.g. device data or zone data. Actual checksum value. Format int varchar varchar TABLE 19 Field FABRIC_COLLECTION Definition Format FABRIC_ID * COLLECTOR_NAME * SEED_SWITCH_IP LAST_SEED_SW_ MODIFICATION Fabric ID, foreign key to the FABRIC table. int Name of the collector, e.g., NameServerInfoCollector, TopologyCollector, ZoneInfoCollector, ActiveZoneInfoCollector. varchar IP address of the switch which serves as the seed varchar switch. This is the switch from which above mentioned fabric level collectors get their information. 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 Size 32 16 Size 256 128 Brocade Network Advisor Documentation Updates 23 53-1002363-02