ImportedVMPool Table

The ImportedVMPool table holds all of the virtual machine pools which have been retrieved from the source connections and the number of processors and cores that are assigned to each pool.

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 `ImportedVMPool` table
Database Column	Details
`PoolName`	Type: text (max 100 characters). Key. Nullable The name of the pool.
`VCObjectID`	Type: text (max 256 characters). Nullable The identifier of the virtual machine folder in Virtal Center.
`ParentName`	Type: text (max 100 characters). Nullable The name of the parent pool. This is the PoolName property for the parent pool.
`PoolFriendlyName`	Type: text (max 256 characters). Nullable The friendly name of the pool.
`HostComputerID`	Type: big integer. Key. Nullable The identifier used in the source connection for the computer which is hosting the pool.
`ObjectType`	Type: text (max 256 characters). Key. Nullable The type of pool.
`ComplianceConnectionID`	Type: integer. Key. Nullable The identifier for a data source connection in the `ComplianceConnection` table.
`ParentObjectType`	Type: text (max 256 characters). Nullable The type of pool of the parent.
`NumberOfProcessors`	Type: decimal. Nullable The number of processors available to this pool.
`NumberOfCores`	Type: decimal. Nullable The number of cores available to this pool.
`NumberOfLogicalProcessors`	Type: integer. Nullable The active number of threads used by this pool.
`MaxNumberOfLogical Processors`	Type: integer. Nullable Maximum number of threads allocated to this pool of type processor set.