Brocade Network Advisor IP User Manual 1593
53-1003056-01
Database tables and fields I
TABLE 491 VM_VIRTUAL_MACHINE
Field Definition Format Size
ID Uniquely identifies the virtual machine serial
HOST_ID Identifies the server that contains this VM int
HYPERVISOR_VM_ID The VM number assigned by the hypervisor.
Some hypervisors identify VMs by number as
well as by name
int
NAME User-assigned name for the VM varchar 80
DESCRIPTION Optional user-entered notes describing the VM.
(Annotation in VMware terminology.)
varchar 256
OS Operating system name and version. varchar 64
STATUS VM status. 0 = stopped, 1 = running, 2 =
suspended.
smallint
VCPU_COUNT Number of virtual CPUs used by the VM. int
CPU_RESOURCES Summary of CPU resource configuration.
Format may depend on VM vendor.
varchar 64
MEM_RESOURCES Summary of memory resource configuration.
Format may depend on VM vendor.
varchar 64
IP_ADDRESS The primary IPv4 or IPv6 IP address used by the
VM on the management LAN, if any.
Primary is defined by the VM vendor.
varchar 32
HOSTNAME The primary hostname assigned to this VM. varchar 128
BOOT_TIME The date and time the VM was last started. timestamp
DATASTORE_NAME The user-assigned name for the VMs datastore.
The datastore holds the VMs virtual disks,
swap file, and configuration data.
varchar 80
DATASTORE_LOCATION The location of the VMs datastore May be a
SAN target disk or a locally-attached host disk
folder.
For VMware, this is a target LUN name.
varchar 64
NODE_WWN The Node WWN for this VM. If NPIV is not being
used, this will be the same as the Node WWN
in the host''s DEVICE_ENCLOSURE record. If
NPIV is being used, each VM has a unique
Node WWN.
char 23
UUID varchar 64
BINARY_IP IP address in binary format. bytea
CONNECTION_STATE The connectivity state of a virtual machine.
0 = not available
1 = connected
2 = disconnected
3 = inaccessible
4 = invalid
5 =orphaned
smallint
COMMITTED_STORAGE Used storage by a particular virtual machine. varchar 64