SoftwareLicenseProcessorPointsData Table

Stores the number of processors/cores on which points-based licensed software is installed and used, and the corresponding points and factors.

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

Database Column

Details

ComplianceComputerID

Type: integer. Key

The computer under examination. Foreign key to the ComplianceComputerSnapshot table.

SoftwareLicenseID

Type: integer. Key

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

InstalledCount

Type: decimal

The number of processors/cores on which a software title licensed by the license is installed.

UsedCount

Type: decimal

The number of processors/cores on which a software title licensed by the license is used.

CapacityCount

Type: decimal

The number of processors/cores that apply to a software title licensed by the license under full capacity counting rules.

PointsFactor

Type: decimal

The number of points consumed per processor/core on this computer for this license.

InstalledPoints

Type: integer

The number of processor/core points required to cover the above InstalledCount.

UsedPoints

Type: integer

The number of processor/core points required to cover the above UsedCount.

CapacityPoints

Type: integer

The number of processor/core points required to cover the above CapacityCount.

LicenseMeasurementID

Type: integer. Key

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

CalculatedConsumption

Type: integer

The calculated consumption value for this license assignment before exemptions or overrides are considered.

Overridden

Type: boolean

Whether this consumption value was the result of an override.