Example of using the audit viewer

You might want to discover if any user opens a database outside of normal working hours, here taken to mean between midnight and 09:00.

Procedure

  1. Click the Selection Criteria tab to display the Selection Criteria page.

  2. Set the date and weekday ranges, time of day, and User ID:

    • In the Between these dates: box, select an appropriate start date. For example, to set a date two months before today, click to highlight the month part of the date and press the down arrow key on your keyboard. In the to: box, leave the end date at today's date

    • In the Between these times: box, enter the time that you want logging to start. For example, the earliest time you can enter is midnight, which you must enter using the 24-hour system as 00:00:00.

    • From the On these days: list, select the appropriate days of the week. For example, to look at all days, leave the setting at its initial value of <All Days>.

    • In the to: time picker to the right, enter the time that you want logging to stop. For example, normal working hours may start at 9 am, which you must enter using the 24-hour system as 09:00:00.

    • You want to see all users who have opened databases outside of normal working hours so you can leave the value in the User box as <Any User>, which is the default. You could use wildcards in this and other text boxes.

    This set of rules will find all the users who have performed a logged action in the date and time ranges you have set. The grid does not change automatically.

  3. Click Refresh to find the log entries matching these rules.

  4. You can filter the log entries by selecting one or more actions. For example, you can only view the actions when a database is opened:

    • Click the Actions tab to display the Actions page. When you first open a log, this page lists all possible actions for the current audit level.

    • Click Clear All to turn off all actions.

    • Turn on only the Database Opened checkbox.

    This sets all the necessary rules. The grid does not change automatically.

  5. Click Refresh to display actions based on all the rules that you have specified. The matching results are displayed in the grid.