Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists › Approaches to Maintaining Keyed Lists › Create a Keyed List

Create a Keyed List

Keyed lists let you create a group and assign values to it. You can then query the group name and any of the values in the group will return a positive result. You can assign values individually or import them from a .csv file. You can create custom keyed lists or add values to predefined lists.

For example, some queries for Privilege Grant reports search for a key value named "Privileged_Groups". When a query includes this value, it returns all rows where that field contains any of the values specified in the group.

To create a Keyed List

1. Click the Administration tab, the Library subtab, and the Keyed List folder.
2. Click New for a new list, or select the list to which you want to add values.

   Keyed List Details appears in the right pane.

3. Type a name and description for the keyed list, and select a type.
4. If you want to import values, go to Step 8. If you want to add values individually, go to Step 5.
5. Click Add at the top of the Keyed List Values table.

   A highlighted row appears in the User column.

6. Click the row, and type a value.
7. Repeat step 4-5 to add additional values.
8. Click Import at the top of the List Details area, browse for the file containing the values you want to import, and click OK.

   The values appear in the Values area.

   Note: You can only import .csv files that do not contain special characters.

9. When you have added all the values you want, click Save.

   The new list appears in the User folder of the Keyed Lists folder.