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.

To sort the log entries displayed in the grid, select the appropriate sort column from the Sort Order list.

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.