VirtualMachineAwaitingInventory Table

VirtualMachineAwatingInventory stores information for virtual machines which are known from the VM Host but which do not yet have inventory.

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 `VirtualMachineAwaitingInventory` table
Database Column	Details
`VirtualMachineAwaiting InventoryID`	Type: integer. Key. Generated ID A unique identifier for the virtual machine awaiting inventory.
`HostComplianceComputerID`	Type: integer. Key. Nullable The virtual machines or partition’s host computer. Foreign key to 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).
`VMPoolID`	Type: integer. Key. Nullable The resource pool that the virtual machine belongs to. Foreign key to the `VMPool` 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).
`VMEnabledStateID`	Type: integer The operational state of the virtual machine (powered on, off, and so on). Foreign key to the `VMEnabledState` table.
`AffinityEnabled`	Type: boolean Set this to `True` if this VM is unable to move to different host computers.
`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.