SoftwareLicenseComputerProblemData Table
SoftwareLicenseComputerProblemData
identifies the problems with individual ComplianceComputer
s
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.
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.
Database Column |
Details |
---|---|
SoftwareLicenseID
|
Type: integer. Key The software license. Foreign key to the |
ComplianceComputerID
|
Type: integer. Key The computer consuming license entitlements. Foreign key to the |
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 |
LicenseMeasurementID
|
Type: integer. Key The license measurement ID. Foreign key to the |