VMHostProperty Table

VMHostProperty stores properties of VM host.

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

Database Column

Details

HostComplianceComputerID

Type: integer. Key

Host computer which has the datastore. Foreign key to the ComplianceComputer table.

VMTypeID

Type: 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.

CloudServiceInstance TypeID

Type: integer. Nullable

Cloud instance type defined by provider. Foreign key to the CloudServiceInstanceType table

CloudServiceRegionID

Type: integer. Nullable

Region of the instance. Foreign key to the CloudServiceRegion table.

AvailabilityZoneID

Type: integer. Nullable

Location of the instance. Foreign key to the AvailabilityZone table

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.