Administration Guide › Queries and Reports › Preparing to Use Reports with Keyed Lists › Enabling Dynamic Values Import › Create a CA IT PAM Process to Generate a Values List

Create a CA IT PAM Process to Generate a Values List

You can create a process in CA IT PAM for each key values list that you want to be able to generate on demand. Use your CA IT PAM documentation for details on process creation. Each process must meet CA Enterprise Log Manager requirements regarding InputKey, the ValueList and FaultString local process parameters, and the Success and Failure calculation operators.

Use the following guidelines:

• The process must accept the selected key as InputKey.
• The process must define the following two local process parameters:
  • ValueList retrieves the value list
  • FaultString retrieves the error string

  Note: CA Enterprise Log Manager requires these exact parameter names be used as output interface parameters.

• The process must contain the following two calculation operators:
  • Success calculation operator: Process.ValueList =<variable containing comma-separated list of values>
  • Failure calculation operator: Process.FaultString =<variable containing error message>

If you create a script, consider these additional guidelines:

• If your script selects columns from a database table, an IT PAM agent must exist on the server where the SQL Server 2005 is installed. SQL Servers must be listed in your domain under All Touchpoints. The SQL Server containing key data must display the agent name for the SQL Server.
• The inline script must run the sqlcmd utility to retrieve the desired list.

More information:

Configure CA IT PAM Integration for Dynamic Values