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

Details

RegionID

Type: integer. Key

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

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

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

IsEligibleInventory

Type: boolean

Is the device eligible for inventory at consumption calculation

PVUConsumption

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.

CalculatedByILMT

Type: boolean

Is the consumption imported from ILMT?

LicenseMeasurementID

Type: integer. Key

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