Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists

Preparing to Use Reports with Keyed Lists

All reports are built from one or more queries. Some queries used in predefined reports are designed to select all values from a given table where a certain attribute field contains a value used as criteria for compiling the list of key values. For example, an assets table has an IsCritical field. A query that selects all asset names from the asset table where IsCritical equals Yes, would select only the names of critical assets. These names could be returned to CA User Activity Reporting Module to refresh the values for the Critical_Assets key.

Preparing to use predefined reports with keyed lists involves the following tasks:

• (Optional) Enabling dynamic values import, if you use CA IT PAM.
• Creating keyed lists for predefined keys that have no predefined values.
• Customizing keyed lists for predefined keys that have predefined values.
• Maintaining keyed lists used in the predefined reports you want to use. Update each keyed list with current values.

In addition, you can add new keys for custom reports that use keyed lists and then add values for each new key. You can also add values to the Business_Critical_Sources key and the ELM_System_Lognames key for on demand queries of your own design.