Use the Audit Log dashboard to view the audit log from Advanced Server database instances (see Figure 8.9).
To open the Audit Log dashboard, right click on a server or agent node, and select
Audit Log Analysis from the
Dashboards menu. You can also open the
Audit Log dashboard by navigating through the
Dashboards menu (located on the
Management menu).
The Audit Log dashboard displays the audit records in reverse chronological order (newest records at the top, oldest records towards the bottom).
•
|
Use the From field to specify a start date for the report. Click the mouse button in the field to open a calendar and select a start date.
|
•
|
Use the To field to specify an end date for the report. Click the mouse button in the field to open a calendar and select an end date.
|
•
|
Use the Username field to display only those entries where the activity was initiated by the given Postgres user.
|
•
|
Use the Database field to display only those entries where the activity was issued on the given database.
|
•
|
Use the Command Type field to display only those entries where the activity was of the given type. Command types you can specify are idle, authentication, and SELECT. (For viewing SQL statements from user applications, specify the idle command type.)
|
Click Filter to apply the filtering criteria to the log entries.