SoftwareLicenseGroupAssignmentHistory Table

FlexNet Manager Suite (Cloud)

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.

FlexNet Manager Suite (Cloud)

Current