Filter audit reports

Before you begin

The reporting database must be installed before you can proceed.

Procedure

  1. In the SQL Server Reporting Services web interface, click the View tab.
  2. To set the time range of audit reports, in the Record Start Date and Record End Date fields, enter the date and time.
  3. To filter reports, from the Audit Type and Audit Topic drop-down lists, select an item or enter search criteria in one of the following fields.
    • Message
    • Username
    • Location
    • Context
    Note: Wildcard searches using the % character are supported. For example, you can search for "topic % modified" in the Message field and get all reports where the message included entries such as: topic modified, topic configuration has been modified, and topic events modified.