SoftwareLicensePVUPointsConsumedPerClusterSCD Table

SoftwareLicensePVUPointsConsumedPerClusterSCD records how many PVU counts and their corresponding core counts have been consumed for a given license by a given kubernetes cluster.

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 `SoftwareLicensePVUPointsConsumedPerClusterSCD` 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.
`ClusterID`	Type: integer. Key The kubernetes cluster. Foreign key to the `Cluster` table.
`ProductRatio`	Type: integer. Key The product part of the conversion ratio for the given license.
`ParentProductRatio`	Type: integer. Key The parent product part of the ratio for the given license.
`MetricQuantity`	Type: integer
`MetricConvertedQuantity`	Type: integer
`MetricName`	Type: text (max 64 characters). Key The type of metric that is being represented.
`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.