SoftwareLicensePVUPointsConsumedPoolsSCD Table

SoftwareLicensePVUPointsConsumedPoolsSCD records pool details and relationships for devices consuming PVU points on a PVU license.

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 `SoftwareLicensePVUPointsConsumedPoolsSCD` table
Database Column	Details
`RegionID`	Type: integer. Key The region consumption is being recorded for. Foreign key to the `Region` table. If NULL, device not belonging to any region
`SoftwareLicenseID`	Type: integer. Key The license being assessed. Foreign key to the `SoftwareLicense` table.
`SoftwareTitleProductID`	Type: integer. Key The software title product the consumption is being recorded for. Foreign key to the `SoftwareTitleProduct` table.
`HostID`	Type: integer. Key The host machine of this pool. Foreign key to the `ComplianceComputer` table.
`PoolID`	Type: integer. Key The identifier of this resource pool. Primary key referenced by the SoftwareLicensePVUPointsConsumedComputersSCD table.
`PoolPathID`	Type: text (max 128 characters) A numerical representation of the path of this pool, constructed from `VMPoolID` values (something like: “1.2.”).
`ParentPoolID`	Type: integer. Nullable The parent identifier of this resource pool.
`PoolFriendlyName`	Type: text (max 256 characters) The friendly name of the pool.
`VMPoolTypeID`	Type: integer The type of pool. Foreign key to the `VMPoolType` table.
`CoreSubcapacityLimit`	Type: integer The maximum number of cores that can be consumed for the license on this resource pool.
`CoreSubcapacity`	Type: integer. Nullable The number of cores consumed for the license on the resource pool.
`IsCapped`	Type: boolean Does this layer implement hard partitioning for this license?
`ValidFrom`	Type: datetime. Key The start time of the PVU usage.
`ValidTo`	Type: datetime The end time of the PVU usage.
`LicenseMeasurementID`	Type: integer. Key The snapshot ID. Foreign key to the `LicenseMeasurement` table.