SoftwareLicenseChangeEvent Table

The SoftwareLicenseChangeEvent table holds the details of all license change events.

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

Database Column



Type: integer. Key

A unique identifier and foreign key to the ComplianceEvent table.


Type: integer. Key

The license involved in the change event. Foreign key to the SoftwareLicense table.


Type: integer. Key

The software title that needs to be added or removed. Foreign key to the SoftwareTitle table.

SoftwareLicenseChange EventSourceID

Type: integer

What caused the event. Foreign key to the SoftwareLicenseChangeEventSource table.

SoftwareLicenseChange EventReasonID

Type: integer

The type of event. Foreign key to the SoftwareLicenseChangeEventReason table.

SoftwareTitleLicense ReasonID

Type: integer. Nullable

When a software title has been added to a license, the reason it has been added (ie because upgrade rights allow it, for example). Foreign key to the SoftwareTitleLicenseReason table.