Summary

This article explains what the dbo.ComplianceHistoryLimited_MT database table is for in FlexNet Manager Suite, and how to relates to the dbo.ComplianceHistory_MT table.

Details

The dbo.ComplianceHistory_MT and dbo.ComplianceHistoryLimited_MT tables in the FlexNet Manager Suite compliance database contain an "audit log" detailing changes made to many different types of records.

The dbo.ComplianceHistoryLimited_MT table that exists in databases that have been upgraded from a version of FlexNet Manager Suite 2015 Rx or earlier to a newer version. It contains details of changes made prior to the upgrade from a FlexNet Manager Suite 2025 Rx or earlier version to 2016 or newer version.

Details of changes made to records by FlexNet Manager Suite 2016 and newer versions are stored in the dbo.ComplianceHistory_MT table..

The dbo.ComplianceHistory view can be used to access a unified set of records from both underlying tables.

A primary difference between the schema of the old and new tables is that the datatype of the dbo.ComplianceHistoryLimited_MT.ComplianceHistoryID column is INT while the dbo.ComplianceHistoryLimited_MT.ComplianceHistoryID column is BIGINT.

These tables are often the top 2 consumers of disk space in the compliance database.