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	Details
`ComplianceActionHistoryID`	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.
`History`	Type: text Detailed information about the action performed.
`HistoryParameters`	Type: text Details of parameters changed and their changed values.
`AssociatedObjectID`	Type: integer The ID of the contract or license associated with the action.
`AssociatedObjectName`	Type: text (max 512 characters) The name of the contract or license associated with the action.
`Comment`	Type: text (max 1024 characters) Comments recorded about the change by the operator.
`CreationUser`	Type: text (max 512 characters) The username of the operator who made the change.
`CreationDate`	Type: datetime The date of the change.