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

Customize Keyed Values for Critical_DDL_Actions

You can use a predefined report and its associated query to monitor the occurrence of critical DDL actions. You can use the default keyed list only or you can modify it. Predefined values include Assembly Drop, Edition Drop, Function Deletion, Function Modify, Package Deletion Package Modify, Procedure Deletion, Procedure, Modify, Table Deletion, Table Modify, Table Purge, Trigger Deletion, and Trigger Disable.

To customize the list, you can remove a predefined value for a DDL action. The predefined list includes all valid DDL actions recorded in CEG fields.

The report that uses this keyed list includes:

• Excessive (5) DDL Activity on Production Database in Last Hour

If you create a custom query that uses this key, define the filter as follows:

To customize keyed values for Critical_DDL_Actions

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

   A list of keys to which you add user-defined values is displayed at the bottom of the main pane.

3. Select the key, Critical_DDL_Action.

   The predefined values appear.

4. Take one or more of the following actions to update this list:
   • Update the list manually:
     • Click Add Value and enter a new value to include in the keyed list.
     • Select a value and click Remove Value to delete the value from the list.
     • Select a value, click Edit Value, modify the value and click OK.
   • Update the list with export/import:
     1. Click Export Values to export the current list.
     2. Open the exported list, edit the list to change its values, and save the file.
     3. Click Import Values to import your edited list.
   • Click Import Values to import the values in an updated csv file.
   • If the values for this key are dynamically generated by the configured 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.