SoftwareLicensePVUPointsPeakConsumedData Table

SoftwareLicensePVUPointsPeakConsumedData records current PVU consumption per host and region for the current reporting period.

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 SoftwareLicensePVUPointsPeakConsumedData table

Database Column



Type: integer. Key

The region consumption is being recorded for. Foreign key to the Region table.


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. Key. Nullable

The host contributing consumption. Foreign key to the ComplianceComputer table.


Type: boolean

Is the device eligible for inventory at consumption calculation


Type: decimal

The PVU points consumed for the host and license in the region at the time of the peak. This value will include any adjustments made for devices which have overrides or require full capacity consumption.


Type: boolean

Is the consumption imported from ILMT?


Type: integer. Key

The license measurement ID. Foreign key to the LicenseMeasurement table.