ComputerResourceVirtualMachine Table

ComputerResourceVirtualMachine is a table containing the type and normalized UUID of virtual machines and the host they are currently known to be on. The normalized UUID is the virtual machine UUID with hyphen and white space characters removed.

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 ComputerResourceVirtualMachine table

Database Column

Details

ComputerResourceID

Type: integer. Key

The host the virtual machine is currently known to be on. Foreign key to the ComputerResourceData table.

ComputerResourceVMTypeID

Type: integer. Key

Type of virtual machine or partition. Foreign key to the ComputerResourceVMType table.

NormalizedUUID

Type: text (max 100 characters). Key

The normalized UUID of the virtual machine.