SoftwareLicensePVUPointsConsumedPerRegionSCD Table

SoftwareLicensePVUPointsConsumedPerRegionSCD records PVU consumption for a given license in a given region.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

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

RegionID

Type: integer. Key

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

PVUSubcapacity

Type: integer

The number of PVU points consumed for the license in the region.

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 LicenseMeasurement table.