Use the Audit Log dashboard to view the audit log from Advanced Server database instances (see Figure 6.8).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).To view older audit records that do not appear in the window, use the vertical scroll bar controlling the list of audit records (the innermost scroll bar of the two located on the right-hand side of the window). As you move the scroll bar towards the bottom of the window, older audit records are continuously loaded and displayed.You can use filtering to limit the number of audit records that are displayed. Click Show Filters to expose the filters panel (see Figure 6.9).Use the fields in the filters panel to provide certain selection criteria for the audit records you wish to display.
• 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.