SoftwareLicensePVUPointsConsumedPerHostSCD Table

SoftwareLicensePVUPointsConsumedPerHostSCD records how many PVU counts and their corresponding core counts have been consumed for a given license by a given computer.

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 `SoftwareLicensePVUPointsConsumedPerHostSCD` 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.
`ComplianceComputerID`	Type: integer. Key The host computer. Foreign key to the `ComplianceComputer` table.
`EligibleForSubCapacity`	Type: boolean Whether the device is eligible for contributing sub capacity consumption to the license Device is eligible if The license setting has ‘Allow sub-capacity licensing for sources other than approved IBM tools and FlexNet Manager Suite’ OR IF license setting is ‘Use sub-capacity license calculations where available’ AND The Host\Computer is inventoried by Flexera agent. AND The system has ILMT mode turned on
`PVUPerCore`	Type: decimal The number of PVU point per core for the license on the computer.
`PVUSubcapacityLimit`	Type: decimal The maximum number of PVU points can be consumed for the license on the computer.
`PVUSubcapacity`	Type: decimal The number of sub-capacity PVU points consumed for the license on the computer.
`CoreSubcapacityLimit`	Type: integer The maximum number of cores that can be consumed for the license on the computer.
`CoreSubcapacity`	Type: integer The number of cores consumed for the license on the computer.
`CalculatedConsumption`	Type: decimal The calculated consumption value for this license assignment before exemptions or overrides are considered.
`ProcessorCount`	Type: integer. Nullable The number of processors consumed for the license on the computer.
`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.