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

E Database tables and fields TABLE 41 Field DEVICE_ENCLOSURE (Continued) (Continued) Definition Format Size TRACK_CHANGES Flag to enable/disable tracking. Default value is 0. smallint LAST_UPDATE_TIME Last time at which the host information was updated. timestamp LAST_UPDATE_MODULE Module which updated the host information. smallint TRUSTED Flag to mark the enclosure trusted. Default value is 0. smallint CREATION_TIME Time when enclosure was created. Default is 'now()'. timestamp MISSING Flag to indicate missing enclosure. Default value is 0. smallint MISSING_TIME Time when the enclosure is found to be missing. timestamp HOST_NAME Host Name corresponding to the Device Enclsoure. varchar 256 SYSLOG_REGISTERED SysLog flag that indicates if syslog has been enabled smallint or not. VIRTUALIZATION If this enclosure is a host, this column indicates whether the host is running a virtualization hypervisor. 0 = unknown 1 = no supported hypervisor present 2 = VMware ESX 3 = Microsoft Hyper-V. Default value is 0. smallint MANAGED_ELEMENT_ID A unique managed element ID for a managed host.If int the device enclosure is manually created (does not represent a managed host) then the field is null. Also a foreign key reference to the MANAGED_ELEMENT table. TABLE 42 Field FABRIC Definition Format Size ID* int SAN_ID Foreign key to SAN table; usually 1 since there is only int one SAN. SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to char 23 discover the fabric. NAME User-assigned fabric name. varchar 256 CONTACT User-assigned "contact" for the fabric. varchar 256 LOCATION User-assigned "location" for the fabric. varchar 256 DESCRIPTION User-assigned fabric description. varchar 256 TYPE Type of fabric: 0 = legacy fabric 1 = base fabric 2 = logical fabric smallint SECURE 1 = it is secured fabric. smallint 32 Brocade Network Advisor Documentation Updates 53-1002363-02