The Smart Instrumentation System Administrator can trim audit trail data and save the data to external files. The format, location and path configuration of these files depends on the platform you are using (Oracle or SQL Server).
-
When using Oracle, these files appear as .sql files on your Windows server.
-
When using SQL Server, these files appear as .txt files on your Windows server.
You need to back up these files to enable loading of the trimmed audit trail data to the CHANGES_LOG table of a domain. The software records the audit trail data in the CHANGES_LOG table that exists in each domain. To learn more about trimming and loading audit trail data, see, Managing Audit Trail Data.
The external file containing audit trail data has a filename made up of the date range within which the data was trimmed, the domain name, the CHANGES_LOG table name, and the filename which the System Administrator has defined in the Administration module before trimming. The following is an example of an external file with audit trail data:
20010614_20011015_<domain name>#CHANGES_LOG#<user-defined filename>.
The audit trail period segment displays the date range in the following order: year, month, and day.