You can archive Metrics Management audit trail events to either a CSV or XML file. Once the archive file is created, these audit trail events are removed from the database. You can also use the Metrics Management Console to schedule archiving of audit trail events.
How to archive the audit trail information
1 Choose File➛Open Servers and Databases.
2 Select a database in the main window, and choose Database Tools.
3 Choose Audit Archive. In Verify User Credentials, provide login credentials and choose OK.
In the Most recent archive section of Archive Audit, shown in Figure 10‑49, statistics display for the last time you archived the audit trail events:
Figure 10‑49 Archive audit statistics
The date you archived the data
The number of audit trail events written to the archive file
The location of the archive file
The user name of the person who archived the data
The workstation from which the archive instruction was issued
4 In Archive format, select the file type, CSV or XML, in which to store audit information.
5 In Archive location, in Folder, select a location from the list, or choose Browse and navigate to the location to store the file and choose OK.
6 In Filename, provide the name of a file in which to save your audit information.
7 Choose Archive to save the changes.
The first time Archive Audit runs, the fields under Most recent archive displays N/A. The next time that Archive Audit runs, the fields displays valid information. If auditing is not enabled, then no data is archived.
The date you archived the data