SoftwareLicenseGroupAssignmentHistory Table

SoftwareLicenseGroupAssignmentHistory is used to keep track of changes made to assignments of software license entitlements to enterprise groups.

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

Database Column


SoftwareLicenseGroup AssignmentHistoryID

Type: integer. Key. Generated ID

A unique identifier for the history record.


Type: text (max 128 characters). Key

This is the primary group that had a change of assignments. Foreign key to the GroupEx table.


Type: text (max 128 characters). Key. Nullable

If assignments were transferred, this is the source group who had assignments taken away. Foreign key to the GroupEx table.


Type: text (max 500 characters). Nullable

The path of the group that assignments were transferred from. This field is used to display the group name (at the time that the transfer took place) when showing history after the group has been deleted.


Type: datetime

The date of the change.


Type: integer. Key

The license for which entitlements are being assigned. Foreign key to the SoftwareLicense table.


Type: text (max 60 characters)

The operator who made the change.


Type: text (max 2000 characters). Nullable

Comments recorded about the change.


Type: integer

The number of assignments added to or removed from the group.


Type: integer

The progressive total of assignments to the group following this change.

SoftwareLicenseGroup AssignmentHistoryTypeID

Type: integer. Key

The type of history record. This records the kind of change that was made (eg, a flat increase/decrease of the assignment count, a transfer, and so on). Foreign key to the SoftwareLicenseGroupAssignmentHistoryType table.