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

1142 Brocade Network Advisor SAN User Manual
53-1002167-01
Database tables and fields
E
TABLE 391 VM_HOST
Field Definition Format Size
ID
Identifies a server running a supported hypervisor.
The ID value is the same as the ID of the correspond-
ing DEVICE_ENCLOSURE record.
int
NODE_WWN The Node WWN for this host. char 23
HYPERVISOR_NAME Hypervisor name and version, such as VMware ESX
Server v3.5.0
varchar 64
HYPERVISOR_TYPE Numeric hypervisor type ID. 1 = VMware, 2 =
Hyper-V.
The default value is 0.
smallint
CPU_COUNT Number of CPUs in the server.
The default value is 0.
int
CPU_TYPE Text summary of CPU hardware, such as: Intel(R)
Xeon(TM) CPU 2.6 GHz
varchar 64
CPU_RESOURCES
Text summary of CPU resources, such as "20 GHz
total, 15 GHz reserved". May be a different format for
different VM vendors
varchar 64
MEM_RESOURCES
Text summary of memory resources, such as "7 GB
total, 5 GB reserved". May be a different format for
different VM vendors
varchar 64
LICENSE_SERVER IP address or hostname of VM Hypervisor''s license
server.
varchar 128
BOOT_TIME Date and time that the host was last started timestamp
TABLE 392 VM_LUN
Field Definition Format Size
ID Uniquely identifies this LUN int
HOST_ID Identifies the server that accesses this LUN. int
NAME The VM-assigned device name for this LUN, such as
vmhba1:0:0. For VMware, this is the canonical
name.'
varchar 512
NODE_WWN The Node WWN for the storage device (target) that
contains this LUN
char 23
VENDOR Vendor name, such as Seagate. varchar 64
MODEL Target model name, such as ST581 varchar 64
SERIAL_NUMBER The device''s serial number varchar 64
TYPE 0 = disk, 1 = tape.
The default value is 0.
smallint
CAPACITY For disks, the disk capacity in GB.
The default value is 0.
double
precision
STATUS The status reported by the host. 0 = offline, 1 =
online.
The default value is 0.
smallint