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

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