SoftwareLicenseReconcileExemptionReasonData Table

The SoftwareLicenseReconcileExemptionReasonData table stores the exemption reasons generated by the license reconcile.

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

Database Column

Details

SoftwareLicenseID

Type: integer. Key

Foreign key to the SoftwareLicenseSnapshot table

ComplianceComputerID

Type: integer. Key. Nullable

Foreign key to the ComplianceComputerSnapshot table

ComplianceUserID

Type: integer. Key. Nullable

Foreign key to the ComplianceUserSnapshot table

SoftwareLicense ExemptionReasonID

Type: integer. Key

Foreign key to the SoftwareLicenseExemptionReason table

AccessingUserID

Type: integer. Key. Nullable

Foreign key to the AccessingUserSnapshot table

LicenseMeasurementID

Type: integer. Key

The snapshot ID. Foreign key to the LicenseMeasurement table.