VirtualMachine

Holds information for virtual machines.For Hyper-V specific columns see MSDN WMI Msvm_ComputerSystem class.

Fields

Field	Type	Description
AnalysisExtras	xml	Holds additional analysis data
Container	bit	True if the virtual machine is a container
Created	datetime2	Date/Time this VM entity was created in the database
CreatedGUID	uniqueidentifier	GUID of the scan file that created this VM
DatacenterID	bigint	Internal ID that references the Datacenter entity (Foreign Key)
ElementName	nvarchar	A display name for the object. This property is inherited from CIM_ManagedElement, and it is always set to the display name of the computer for a virtual machine.
EnabledDefault	bigint	An administrator's default or startup configuration for the enabled state of an element
EnabledState	bigint	The enabled and disabled states of an element. This property can also indicate the transitions between these requested states.
EnhancedSessionModeState	bigint	Hyper-V: See MSDN documentation
ExtraData	nvarchar	Extra data for this object (JSON)
FailedOverReplicationType	bigint	Hyper-V: See MSDN Documentation
FirstScan	datetime2	Date/Time this vm was first scanned
FirstScanGUID	uniqueidentifier	GUID of the first scan that scanned this VM
GuestConfiguredOperatingSystem	nvarchar	Guest operating system as configured for the VM for hypervisors that support this
GuestHostFullyQualifiedDomainName	nvarchar	The guests fully qualified domain name. Used for guest machine to VM mapping.
GuestHostName	nvarchar	The guests host name
GuestOperatingSystem	nvarchar	Dectected Guest operating system as seen from the hypervisor. This usually requires some guest tools to be installed in the guest operating system.
GuestOperatingSystemFamily	nvarchar	Family of the detected guest operating system,
GuestToolsCurrent	bit	True if guest tools were current at scan time
GuestToolsRunningStatus	nvarchar	GuestTools RunningStatus field for VMware virtual machines
GuestToolsVersion	nvarchar	Version of installed VMWare guest tools
GuestToolsVersionStatus2	nvarchar	Guest Tools VersionStatus2 field for VMware virtual machines
HealthState	bigint	Specifies the current health of the element. This attribute expresses the health of this element but not necessarily that of its subcomponents.
HostFullyQualifiedDomainName	nvarchar	Fully qualified domain name of the host that this vm is running on,
HostMachineID	bigint	Internal ID that references the Machine entity (Foreign Key)
HostOperatingSystemFamily	nvarchar	Family of the operatingsystem the hypervisor runs on,
Hypervisor	nvarchar	Name of the hypervisor,
ID	bigint	Internal ID for the VirtualMachine entity (Primary Key)
InstallDate	datetime2	The date and time the virtual machine configuration was created for a virtual machine
InstanceId	nvarchar	Hyper-V Instance Id
InstanceUUID	uniqueidentifier	A unique identifier of the vm. This id should not change in case of rename or move of a vm.
LastApplicationConsistentReplicationTime	datetime2	The time at which the last application-consistent replication was received for the virtual machine
LastHostChange	datetime2	Timestamp this VM migrated last from another host to the current host (v-motion etc)
LastHostChangeGUID	uniqueidentifier	GUID of the scan file that indicated the host change
LastReplicationTime	datetime2	Hyper-V: See MSDN documentation
LastReplicationType	bigint	Hyper-V: See MSDN documentation
LastScan	datetime2	Date/Time this VM was last scanned
LastScanGUID	uniqueidentifier	uuid of the last scan file
MachineID	bigint	Internal ID that references the Machine entity (Foreign Key)
MemoryMB	bigint	RAM that the hypervisor provides
MoRef	nvarchar	For VMWare the object name of the vm
Name	nvarchar	Name of the virtual machine
Notes	nvarchar	Notes
NumberOfNumaNodes	bigint	Hyper-V: See MSDN Documentation
OnTimeInMilliseconds	bigint	For the virtual machine, this property indicates the time, in milliseconds, since the machine was last turned on, reset, or restored at scan time. This time excludes the time the virtual machine was in the paused state.
OperationalStatus	bigint	Operational Status of the virtual Machine. For values see MSDN Documentation.
PoweredOn	bit	True if the VM was powered on at time of scan
ProcessID	bigint	The identifier of the process under which this virtual machine was running at scan time. This value can be used to uniquely identify the instance of Vmwp.exe on the system that is running the virtual machine.
ProvisionedSpaceGB	decimal	Disc space provisioned to this VM
ReplicationHealth	bigint	The replication health for the virtual machine. For values see MSDN documentation.
ReplicationMode	bigint	Hyper-V: See MSDN documentation
ReplicationState	bigint	Replication State of the virtual machine. For values see MSDN documentation.
RequestedState	bigint	The last requested or desired state for the virtual machine as passed to theRequestStateChange method, or 12 (Not Applicable) if no state change is in progress. The actual state of the element is represented by EnabledState. This property is provided to compare the last requested and current enabled or disabled states.
ServiceNowLastExport	datetime2	Date/Time of last export to ServiceNow
ServiceNowLastImport	datetime2	Date/Time of last import from ServiceNow
ServiceNowSysId	uniqueidentifier	Service Now: sys_id of the replciated object
ServiceNowTargetClass	nvarchar	Service Now: class of the replicated object
Status	nvarchar	Hyper-V
StatusDescriptions	nvarchar	Operational Status of the virtual Machine
TimeOfLastConfigurationChange	datetime2	The date and time the configuration of this virutal machine last changed
TimeOfLastStateChange	datetime2	The date and time when the enabled state of the element last changed
UsedSpaceGB	decimal	Used disc space
UUID	uniqueidentifier	A unique identifier of the vm. For VMware this is equal to the hardware serial number and used for vm to host mapping.
VirtualCores	bigint	Virtual cores or virtual processors that the hypervisor provides
VirtualizationManagementSystemID	bigint