SoftwareLicenseGroupAssignmentHistory Table
SoftwareLicenseGroupAssignmentHistory
is used to keep track of changes made to assignments of software license
entitlements to enterprise groups.
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 |
---|---|
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 |
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 |
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 |
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 |