Brocade Network Advisor SAN User Manual v11.1x (53-1002167-01, May 2011)

1006 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
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
or not.
smallint
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
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.
int
TABLE 110 FABRIC
Field Definition Format Size
ID* int
SAN_ID Foreign key to SAN table; usually 1 since there is only
one SAN.
int
SEED_SWITCH_WWN WWN of the virtual switch used as seed switch to
discover the fabric.
char 23
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
TABLE 109 DEVICE_ENCLOSURE (Continued) (Continued)
Field Definition Format Size