ReconcileSoftwareLicenseComputerProblem Table

ReconcileSoftwareLicenseComputerProblem is a license reconciliation staging table for the SoftwareLicenseComputerProblemData table.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

The software license. Foreign key to the SoftwareLicense table.

ComplianceComputerID

Type: integer. Key

The computer consuming license entitlements. Foreign key to the ComplianceComputer table.

SoftwareLicense ComputerProblemTypeID

Type: integer

The type of problem this computer’s inventory causes for a given license. For example, core-based licenses require accurate inventory of processor core counts to determine ther compliance status.

Foreign key to the SoftwareLicenseComputerProblemType table.