SoftwareLicenseComputerProblemData Table

SoftwareLicenseComputerProblemData identifies the problems with individual ComplianceComputers that contributed to an associated license having an unknown compliance status. For example, some license types caculate entitlement consumption based on the number of processor cores present in a computer, but that detail is not available from Microsoft SCCM before version 2012, so computers from this inventory source will cause associated licenses to have unknown compliance status.

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 SoftwareLicenseComputerProblemData 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.

LicenseMeasurementID

Type: integer. Key

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