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



Type: integer. Key

The region consumption is being recorded for. Foreign key to the Region table. If NULL, device not belonging to any region


Type: integer. Key

The license being assessed. Foreign key to the SoftwareLicense table.


Type: integer. Key

The software title product the consumption is being recorded for. Foreign key to the SoftwareTitleProduct table.


Type: integer

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


Type: integer

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


Type: integer

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


Type: datetime. Key

The start time of the consumption.


Type: datetime

The end time of the consumption.


Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.