Audit log entries
The audit log can be sorted, searched, and filtered to make locating specific entries easier.
To navigate through the log entries displayed in the grid, you can:
- Use the scroll bars to scroll horizontally or vertically.
- Click any cell in the grid, then use the Page Up and Page Down keys.
Double-click anywhere on the row of the log entry to display details. For most entries, this
provides the details of the action performed in a separate form. If you are accessing a
log for a SQL Server database, a number of extra options are available:
- Double-clicking rows for actions that changed database records, shows the history of the changed record.
- Text can be copied from rows.
- Information can be appended to the details section of a row (like a Journal Entry, this is in the format of an additional string with the username and timestamp).
Exporting the log entries
You can select Action
>
Export to export the displayed log entries to a comma
separated value text file (.csv file). This file can be read into a spreadsheet or
other visualization tool.
Note: The audit history is not exported.
Printing the log entries
You can select Action
>
Report and click the printer icon from the toolbar (or select
the printer icon from the Report toolbar), to print the log entries displayed in the grid.
Note:
- The audit history is not printed.
- Log entries are printed using Landscape layout.
- You might find that the contents of the Detail column wrap around to the beginning of the next line.
Deleting and archiving the log entries
The only way to delete selected data from the audit log is to create an archive. If you no longer require the data you placed in the archive, you can delete the archive file.
Note: For SQL Server databases, you can back up the whole archive database and then delete it. An
empty archive database is created the next time a user performs an auditable
action.