SoftwareLicensePVUPointsConsumedPerHostSCD Table
SoftwareLicensePVUPointsConsumedPerHostSCD
records how many PVU counts and their corresponding core counts have been consumed for a given license by a given computer.
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.
Database Column |
Details |
---|---|
RegionID
|
Type: integer. Key The region consumption is being recorded for. Foreign key to the |
SoftwareLicenseID
|
Type: integer. Key The license being assessed. Foreign key to the |
SoftwareTitleProductID
|
Type: integer. Key The software title product the consumption is being recorded for. Foreign key to the |
ComplianceComputerID
|
Type: integer. Key The host computer. Foreign key to the |
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 |