Creating a new shared query

A shared query is a set of search criteria that you define for other auditors to use. Shared queries are visible to the auditors you specify. Only the auditor who creates a query can grant permission to other auditors to use the query. You create shared queries by selecting options in Audit Analyzer dialog boxes in exactly the same way as you create private queries. Your selections are then translated into complex expressions in the SQL Server query language. You can also convert a private or quick query to a shared query.

To create a new shared query:

  1. Open Audit Analyzer, select Audit Sessions, right-click, then select New Shared Query.
  2. Type the query name and select the session type, grouping, ordering, and other criteria for the query.

    If you need more information about specifying information for any field in the new query, see Creating a new quick query .

  3. Click Add to add another filter to the criteria for the query, or click OK to save the query and find the sessions that match the criteria you have specified.

  4. Expand Shared Queries, select the query name you specified in Step 2, right-click, then select Properties.

  5. Click the Security tab.

  6. Click Add.

  7. Type the user or group name to identify the auditors who should have permission to use this query, then click OK.

    You can add multiple users or groups from the Select Users or Groups dialog box. You can also type part of the name, then click Check Names to look up user and group names.

  8. Select each user or group, then select the appropriate permissions.

Searching for shared queries

After you publish queries and give other users permission to access them, other auditors can search for and select the shared queries they want to use. The shared queries are not automatically visible to users who have permission to use them.

To find shared queries you have permission to use:

  1. Open Audit Analyzer, select Audit Sessions, right-click, then select Open Shared Queries.
  2. Type the query name or click Show existing queries, then click Find Now.
  3. Select one or more queries from the results returned, then click OK to add the query to your list of Shared Queries.