Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists › Creating Keyed Values for Predefined Reports › Customize Keyed Values for Critical_Database

Customize Keyed Values for Critical_Database

You can use predefined reports and their associated queries to monitor activities involving critical databases. You can use the default keyed list only or you can supplement it with your own values. Predefined values include Master, mysql, information_schema, Distribution, Msdb, TempDB, and sys.

The reports that use the values you supply include the following:

• Authorization Failure Activity on Critical Database by {Log Name | Host | Database | Account}
• Critical Database Failed Activity by {Performer | Log Name | Host | Database | Category | Action}
• Critical Database Management by {Log Name | Host | Database | Action | Account}
• Critical Database Purging Activity by {Log Name | Host | Database | Account}
• Unsuccessful Login Attempt on Critical Database by {Performer | Log Name | Host | Database | Account}

If you create a custom query on critical databases, define the filter as follows:

To create keyed values for Critical_Database

1. Click the Administration tab and the Services subtab.
2. Click Report Server.

   A list of keys to which you add user-defined values appears.

3. Select or create the key, Critical_Database.
4. Take one of the following actions to create this list:
   • Click Add Value and enter each new value to include in the keyed list.
   • Create an Excel spreadsheet with one row, where each column is a single value. Save it as a csv file. Click Import Values to import your edited list.
   • If the values for this key are dynamically generated by the CA IT PAM dynamic values process, click Import Dynamic Values List.
5. Click Save.

   Reports using this keyed list that are generated by scheduled jobs begin reflecting data for the updated values.

More information:

Update a Keyed List with a Dynamic Values Process

Example: Update a Keyed List with a CSV File

Update a Keyed List Manually