ImportedVMHostProperty Table

The ImportedVMHostProperty table holds additional properties for virtual machines hosts which have been retrieved from the source connections.

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

Database Column

Details

ComplianceConnectionID

Type: integer. Key. Nullable

The identifier for a data source connection in the ComplianceConnection table.

ExternalComputerID

Type: big integer. Key. Nullable

The identifier used in the source connection for the virtual machine’s host computer ID.

VMTypeID

Type: big integer. Nullable

The VMHost technology type. Foreign key to the VMType table.

HypervisorVersion

Type: text (max 32 characters). Nullable

The hypervisor version of the VM host.

HyperThreadingEnabled

Type: boolean. Nullable

Set this to True if this VM host has hyper threading enabled.

PowerState

Type: text (max 32 characters). Nullable

The power state of the VM host.

ManagingSoftwareVersion

Type: text (max 32 characters). Nullable

The version of the managing software for the VM host.

ConnectionState

Type: text (max 32 characters). Nullable

The connection state of the VM host to the managing software envrionment.

InstanceType

Type: text (max 256 characters). Nullable

Cloud provider instance type.

Region

Type: text (max 256 characters). Nullable

Region of the host.

AvailabilityZone

Type: text (max 256 characters). Nullable

Location of the host.

AllocationTime

Type: datetime. Nullable

The time that the Dedicated Host was allocated.

ReleaseTime

Type: datetime. Nullable

The time that the Dedicated Host was released.

Autoplacement

Type: boolean. Nullable

Whether auto-placement is on or off.

ServerIP

Type: text (max 256 characters). Nullable

IP of vcenter system.