ComplianceActionHistory Table

ComplianceActionHistory records actions performed in the Compliance portal on a contract or software license, including usage activation/deactivation.

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

Database Column



Type: integer. Key. Generated ID

Unique identifier for the record.

ComplianceAction HistoryResourceID

Type: integer. Key

Identifies the type of action performed. Foreign key to the ComplianceActionHistoryResource table.


Type: text

Detailed information about the action performed.


Type: text

Details of parameters changed and their changed values.


Type: integer

The ID of the contract or license associated with the action.


Type: text (max 512 characters)

The name of the contract or license associated with the action.


Type: text (max 1024 characters)

Comments recorded about the change by the operator.


Type: text (max 512 characters)

The username of the operator who made the change.


Type: datetime

The date of the change.