VirtualMachine Table

VirtualMachine stores extra information for computers identified as virtual machines or hardware partitions.

Note: To cater for multi-tenant mode, this table may contain data for multiple tenants. Access requires that the database TenantID has been set in the SQL Server connection context information. That setting filters an underlying table to produce this view of data for the single, selected tenant.

Table 1. Database columns for `VirtualMachine` table
Database Column	Details
`VirtualMachineID`	Type: integer. Key. Generated ID A unique identifier for virtual machine or partition properties associated with a computer.
`HostComplianceComputerID`	Type: integer. Key. Nullable The virtual machines or partition’s host computer. Foreign key to the `ComplianceComputer` table.
`ComplianceComputerID`	Type: integer. Key The computer associated with these virtual machine or partition properties. Computer in the `ComplianceComputer` table.
`VMTypeID`	Type: integer The type of virtual machine or partition. Foreign key to the `VMType` table.
`UUID`	Type: text (max 256 characters). Nullable The UUID (Universally Unique Identifier) of the virtual machine. Used to match virtual machine properties to their associated `ComplianceComputer`.
`VMName`	Type: text (max 256 characters). Nullable The name of the virtual machine or partition.
`VMLocation`	Type: text (max 256 characters). Nullable The location of the virtual machine on the file system.
`GuestFullName`	Type: text (max 256 characters). Nullable The configured operating system for the guest.
`FriendlyName`	Type: text (max 256 characters). Nullable The friendly name of the virtual machine or partition.
`VCObjectID`	Type: text (max 256 characters). Nullable The ID of the virtual machine in Virtual Center.
`TotalMemory`	Type: big integer. Nullable The total memory of the virtual machine (in bytes).
`VMStateID`	Type: integer The state of the virtual machine, related to whether it is linked to a computer or not. Foreign key to the `VMState` table.
`VMPoolID`	Type: integer. Nullable The resource pool that the virtual machine belongs to. Foreign key to the `VMPool` table.
`ZoneResourceManagement MethodTypeID`	Type: integer. Nullable The resource management method used for this Solaris Zone VM. Foreign key to the `ZoneResourceManagementMethodType` table.
`CPUUsage`	Type: integer. Nullable The maximum CPU usage of the Virtual Machine (measured in MHz).
`MemoryUsage`	Type: big integer. Nullable The maximum memory usage of the Virrtual Machine (in bytes).
`MaxNumberOfLogical Processors`	Type: decimal. Nullable The maximum number of threads this VM is allowed to access.
`VMEnabledStateID`	Type: integer The operational state of the virtual machine (powered on, off, and so on). Foreign key to the `VMEnabledState` table.
`VMSourceTypeID`	Type: integer Whether the virtual machine properties are manually entered or created from inventory. Foreign key to the `VMSourceType` table.
`CreationUser`	Type: text (max 256 characters) The operator who created this record.
`CreationDate`	Type: datetime The date/time when this record was created.
`UpdatedUser`	Type: text (max 256 characters). Nullable The operator who last updated this record.
`UpdatedDate`	Type: datetime The date/time when this record was last updated.
`AffinityEnabled`	Type: boolean Set this to `True` if this VM is unable to move to different host computers.
`CPUAffinity`	Type: text (max 256 characters). Nullable Contains the CPU Affinity value for virtual machines (Host Logical processors)
`CoreAffinity`	Type: text (max 256 characters). Nullable Contains the Core Affinity value for virtual machine
`PartitionID`	Type: text (max 100 characters). Nullable Partition ID generated and used by the managing virtualization platform
`PartitionNumber`	Type: integer. Nullable Number of this partition
`IsHostAssignedManually`	Type: boolean Was the virtual machine assigned to its host manually? This prevents unlinking of the virtual machine.