VMPool Table

VMPool contains information about virtual machine pools (logical groups of VMs or partitions).

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

Database Column



Type: integer. Key. Generated ID

A unique identifier for a virtual machine pool.


Type: text (max 100 characters). Key

The name of the pool.


Type: text (max 256 characters)

The friendly name of the pool.


Type: text (max 1000 characters)

The full path of the pool (including parent pool names).


Type: text (max 256 characters). Nullable

The ID of the virtual machine folder (pool) in Virtual Center.


Type: integer

One more than the number of children this pool has.


Type: text (max 128 characters)

A numerical representation of the path of this pool, constructed from VMPoolID values (something like: “1.2.”).


Type: integer. Key. Nullable

A link to the host computer that this pool exists on. This is a foreign key to the ComplianceComputer table.


Type: integer. Key

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


Type: integer. Nullable

If this pool is a virtual machine or partition itself, this is a link to that virtual machine or partition. Foreign key to the VirtualMachine table.


Type: decimal. Nullable

The number of processors in this pool.


Type: integer. Nullable

The active number of threads in this pool.


Type: decimal. Nullable

The number of cores in this pool.

MaxNumberOfLogical Processors

Type: integer. Nullable

The maximum number of threads assigned for this pool of type processor set.