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

1188 Brocade Network Advisor SAN User Manual
53-1002696-01
Database tables and fields
H
DESCRIPTION Description if any. varchar 256
COMMENT_ Comments if any. varchar 256
IP_ADDRESS IP Address if assigned by user. varchar 128
VENDOR Vendor name. varchar 256
MODEL Device enclosure Model. varchar 256
SERIAL_NUMBER Serial Number given for the entity. varchar 256
FIRMWARE Firmware running on the device which is not
applicable for device enclosure logical entity.
varchar 256
USER_DEFINED_VALUE1 User-defined custom value. varchar 256
USER_DEFINED_VALUE2 User-defined custom value. varchar 256
USER_DEFINED_VALUE3 User-defined custom value. varchar 256
HCM_AGENT_VERSION Version of the HCM agent running on the host varchar 32
OS_VERSION Operating system version for the enclosure varchar 256
CREATED_BY Module which created this enclosure: 0->Manual,
1->HBA 2->VM.
Default value is 0.
int
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 77 DEVICE_ENCLOSURE (Continued)
Field Definition Format Size