ComplianceEventHistory Table

FlexNet Manager Suite 2020 R1 (On-Premises)

ComplianceEventHistory stores a history of state changes for each compliance event.

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 `ComplianceEventHistory` table
Database Column	Details
`ComplianceEventHistoryID`	Type: integer. Key. Generated ID Unique identifier for an event history record.
`ComplianceEventID`	Type: integer. Key The event whose history is being recorded. Foreign key to the `ComplianceEvent` table.
`UserName`	Type: text (max 60 characters) The operator who made the change.
`HistoryDate`	Type: datetime The date of the change.
`FieldName`	Type: text (max 256 characters). Nullable The field name that has been updated. Foreign key to the `ComplianceResourceString` table.
`OldValue`	Type: text (max 500 characters). Nullable The value before the change.
`NewValue`	Type: text (max 500 characters). Nullable The value after the change.

FlexNet Manager Suite (On-Premises)

2020 R1