ReconcileSoftwareLicenseProcessorData Table

This serves as an intermediate table during reconciliation process to store the number of processors (or cores) on which licensed software is installed and used for each computer, and the calculated points.

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

Database Column

Details

ComplianceComputerID

Type: integer. Key

The host computer under examination. Foreign key to the ComplianceComputer table.

SoftwareLicenseID

Type: integer. Key

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

VMLayerID

Type: integer. Key. Nullable

The virtual machine layer under examination. Foreign key to the ReconcileVirtualMachineLayer table.

IsHost

Type: boolean. Key

Does this refer to the top layer for this host?

IsCapped

Type: boolean

Does this layer implement hard partitioning for this license?

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.

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.

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.