Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists › Approaches to Maintaining Keyed Lists › Determine Keyed List Usage for a Query

Determine Keyed List Usage for a Query

A good practice is to keep keyed lists updated with current values. To update a keyed list used in a particular report or alert, first identify the queries used in the report or alert. Then, determine the keyed list used in the source query or query.

Keyed lists are displayed in the Report Server configuration.

Queries that use a keyed lists often reference the keyed list name in the query name. For example, there are queries with "Default Accounts" or "Privileged Group" in the query name.

To find a keyed list name so that you can update its values, consider using one of the steps in the following procedure.

To determine keyed list usage, if any, for a query

1. Verify advanced query filters in a copy of the query:
   1. Click Queries and Reports.
   2. (Optional) Select a query tag.
   3. Select a query from the query list and select copy from the Options drop-down list.

      The Query Design wizard appears.

   4. Click the Query Filters step and then click the Advanced Filters tab.

      A query using a keyed list has a filter with the operator Keyed. The value is the name of the keyed list. In the following example, Default_Accounts is the keyed list.

   5. Click Cancel. The user-defined query copy is not saved.

      

2. Alternatively, export a copy of the query to an XML file and verify the Filter logic statement for the val=value where oper="KEYED".
   1. Click Queries and Reports.
   2. (Optional) Select a query tag.
   3. Select a query from the query list and select copy from the Options drop-down list.

      The Query Design wizard appears.

   4. Click Save and Close.

      The query copy you created appears under User in the Query List.

   5. Select this user-defined query from the query list, expand the Options drop-down list, and select Export Query Definition.

      The Export User Query Definitions pane appears with the query in the Selected Queries list.

   6. Click Export.
   7. Select the location for downloading and edit the file name User Queries.xml to a unique name. Then click Save.
   8. Open the XML file.
   9. Scroll to the Filter logic statement and notice oper="KEYED" val="<name of the keyed list>".

      An example follows: