1582 Brocade Network Advisor IP User Manual
53-1003056-01
Database tables and fields
I
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 473 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 474 VM_HOST_PROXY_SWITCH
Field Definition Format Size
ID Unique generated database identifier. se rial
VM_HOST_ID Foreign Key to the vm_host table int
TABLE 472 VM_HOST (Continued)
Field Definition Format Size