The Audit Log Analysis Dashboard

The Audit Log Dashboard allows you to browse the audit logs that have been collected from Advanced Server instances which have enabled audit logging and collection with the Audit Manager. If the Audit Log Dashboard is opened from the Global level, it will display logs from all servers. If opened from the Agent level, it will show logs from all servers monitored by that Agent. If opened from the Server level, it will show logs from that server only.

Audit log analysis dashboard

The Audit Log Dashboard header includes the date and time that the page was last updated, and a current count of triggered alerts.

Audit Log table entries are loaded on demand in batches; to load additional entries, scroll to the end of the log and the additional rows will be automatically loaded from the database and added to the table. Log entries are show in chronological order, most recent first.

  • The Id column identifies the PEM agent that monitors the server that initiated the recorded transaction.
  • The Server column identifies the server that initiated the recorded transaction.
  • The Timestamp column shows the date and time that the log entry was made.
  • The User Name column shows the user which executed the statment in the audit log entry.
  • the Database Name column shows the database on which the statment in the audit log entry was executed.
  • The Process ID column shows the ID of the process which executed the statement in the audit log entry.
  • The Session ID column shows the ID of the session in which the statement in the audit log entry was executed.
  • The Transaction ID column shows the ID of the transaction in which the statement in the audit log entry was executed.
  • The Connection From column shows the client’s address from where the session was connected.
  • The Command column shows the type of command executed.
  • The Message column shows the message associated with the audit log entry.

Click Show Filters to display a panel that you can use to filter the audit log entries that are shown in the table below; click on Hide Filters to close the panel.

Audit log analysis dashboard filters

Use the fields within the filter definition box to describe a selection criteria that PEM will use to select a subset of a report for display:

  • Use the date and time selectors in the From field to specify a starting date and time for the displayed log entries.
  • Use the date and time selectors in the To field to specify an ending date and time for the displayed log entries.
  • Enter a username in the Username field to show log entries for the specified user only.
  • Enter a database name in the Database field to show log entries for the specified database only.
  • Enter a command type (for example; ‘SELECT’, ‘authentication’ or ‘idle’) in the Command Type field to show log entries of that type only.