SoftwareLicensePVUPointsConsumedPerProductSCD Table

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

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 SoftwareLicensePVUPointsConsumedPerProductSCD 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.

PointsConsumed

Type: integer

The number of sub-capacity points consumed for the license on the computer.

ProductRatio

Type: integer

The product part of the conversion ratio for the given license.

ParentProductRatio

Type: integer

The parent product part of the ratio for the given license.

ValidFrom

Type: datetime. Key

The start time of the consumption.

ValidTo

Type: datetime

The end time of the consumption.

LicenseMeasurementID

Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.