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	Details
`SoftwareLicenseGroup AssignmentHistoryID`	Type: integer. Key. Generated ID A unique identifier for the history record.
`GroupExID`	Type: text (max 128 characters). Key This is the primary group that had a change of assignments. Foreign key to the `GroupEx` table.
`FromGroupExID`	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.
`FromGroupExPath`	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.
`HistoryDate`	Type: datetime The date of the change.
`SoftwareLicenseID`	Type: integer. Key The license for which entitlements are being assigned. Foreign key to the `SoftwareLicense` table.
`UserName`	Type: text (max 60 characters) The operator who made the change.
`Comments`	Type: text (max 2000 characters). Nullable Comments recorded about the change.
`NumberAdded`	Type: integer The number of assignments added to or removed from the group.
`Total`	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.