Brocade Network Advisor SAN User Manual v12.1.0 - Manual (Page 1564)

Brocade Network Advisor SAN User Manual 1517
53-1002948-01
Database tables and fields
H
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
VM_DATACENTER_ID A foreign key referencing VM_DATACENTER table
instance to which this host is associated with. int
DVS_HOSTMEMBER_STATU
S
•
1 - disconnected The host is in disconnected or
not responding state.
•
2 - down The host component is down.
•
3 - outOfSync The switch configuration in the
host component is not the same as the
configuration in VirtualCenter server.
•
4 - pending The host component is waiting to be
initialized.
•
5 - up The host component is up and running.
•
6 - warning The host requires attention.
smallint
DVS_PRODUCT_NAME Short form of the product name of proxy switch
module of a dvSwitch. varchar 256
DVS_PRODUCT_VENDOR Name of the vendor of this product. varchar 256
DVS_PRODUCT_VERSION Dot-separated version string. For example, "1.2". varchar 256
CLUSTER_NAME The name of the cluster of which this host is a
member of. varchar 256
MOR_ID The managed object reference number assigned by
the hypervisor. int
UUID UUID to uniquely identify the host. varchar 64
TABLE 415 VM_HOST_END_DEV_CONNECTIVITY
Field Definition Format Size
VM_PHYSICAL_NIC_ID A foreign key referencing VM_PHYSICAL_NIC
(ID) int
INTERFACE_ID A foreign key referencing INTERFACE (ID) int
TABLE 416 VM_HOST_PROXY_SWITCH
Field Definition Format Size
ID Unique generated database identifier. serial
VM_HOST_ID Foreign Key to the vm_host table int
TABLE 414 VM_HOST (Continued)
Field Definition Format Size