Brocade Network Advisor SAN User Manual v12.3.0 User Manual
Page 1801
Brocade Network Advisor SAN User Manual
1749
53-1003154-01
Database tables and fields
H
TABLE 501
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