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	Details
`VMPoolID`	Type: integer. Key. Generated ID A unique identifier for a virtual machine pool.
`PoolName`	Type: text (max 100 characters). Key The name of the pool.
`PoolFriendlyName`	Type: text (max 256 characters) The friendly name of the pool.
`Path`	Type: text (max 1000 characters) The full path of the pool (including parent pool names).
`VCObjectID`	Type: text (max 256 characters). Nullable The ID of the virtual machine folder (pool) in Virtual Center.
`NextChild`	Type: integer One more than the number of children this pool has.
`PoolPathID`	Type: text (max 128 characters) A numerical representation of the path of this pool, constructed from `VMPoolID` values (something like: “1.2.”).
`HostComplianceComputerID`	Type: integer. Key. Nullable A link to the host computer that this pool exists on. This is a foreign key to the `ComplianceComputer` table.
`VMPoolTypeID`	Type: integer. Key The type of pool. Foreign key to the `VMPoolType` table.
`VirtualMachineID`	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.
`NumberOfProcessors`	Type: decimal. Nullable The number of processors in this pool.
`NumberOfLogicalProcessors`	Type: integer. Nullable The active number of threads in this pool.
`NumberOfCores`	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.