ReconcileVirtualMachineLayer Table

This serves as an intermediate table during reconciliation process to store virtual machines, pools and hosts in a generalized tree structure.

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

Database Column

Details

VMLayerID

Type: integer. Key

A unique identifier for a ReconcileVirtualMachineLayer.

HostComplianceComputerID

Type: integer. Key

The host computer on which the layer resides, or the computer itself. Foreign key to the ComplianceComputer table.

VMPoolID

Type: integer. Key. Nullable

The identifier of the virtual pool containing this VM, or the pool itself. Foreign key to the VMPool table.

VMPoolTypeID

Type: integer. Nullable

The type of this VM pool. Foreign key to the VMPoolType table.

VirtualMachineID

Type: integer. Key. Nullable

The identifier of this virtual machine. Foreign key to the VirtualMachine table.

VMTypeID

Type: integer. Nullable

The type of this virtual machine. Foreign key to the VMType table.

ParentVMPoolID

Type: integer. Nullable

The identifier of the parent VM pool of this pool. Foreign key to the VMPool table.

ParentVMLayerID

Type: integer. Key. Nullable

The parent layer. Foreign key to the ReconcileVirtualMachineLayer table.

ComplianceComputerID

Type: integer. Key. Nullable

The identifier of the computer running inside this virtual machine. Foreign key to the ComplianceComputer table.

Name

Type: text (max 256 characters). Nullable

The name of the layer (host/pool/VM).

PartialNumberOfProcessors

Type: decimal. Nullable

The fractional processor count available to this layer.

NumberOfProcessors

Type: decimal. Nullable

The processor count for this layer.

NumberOfCores

Type: decimal. Nullable

The core count for this layer.

MaxNumberOfLogical Processors

Type: decimal. Nullable

The maximum number of logical processors count for this layer.

NumberOfLogicalProcessors

Type: decimal. Nullable

The thread count for this layer.

Depth

Type: integer. Key

The number of layers between this and the host computer.