Example: Finding Components by Alias Name

This example shows a simple report you can create using an Applications Manager modeling view.

If you want to know where a job is referenced in process flows, you can go to the Jobs Selector window, select the job and click Usage. But you might want slightly different information than that. You may want to know where the job is assigned as a process flow component under a particular alias name. Or perhaps you know that an alias name is used for a component in one of your process flows, but you don't remember which one. For cases like this, you can create a report to easily find the information you are looking for.

Creating an Alias Usage Report

This example shows how to create a sample alias report that allows you to enter an alias name as a prompt value to return a list of process flows that include that alias. You can follow these instructions to create this report, or alter them slightly to create your own version. To create this report:

1. Start by giving the report a name, title and type as shown below. You won't need to select a login because you are logging into the Applications Manager database.



Select the CHAIN_NAME, COMPONENT_NAME, and COMPONENT_MODULE columns.

2. Click the Select button to open the Select Tables/Views window.
3. Enter 'AM' in the Search field to view a list of the Applications Manager modeling views.

With the Applications Manager modeling views you don't need an extensive knowledge of the Applications Manager database table structure. Their columns closely match the field names used in the Applications Manager client.

4. Select the AW_CHAIN_COMPONENTS view and click OK.
5. Click New on the Reports window to add columns.
6. On the Select Columns window select the CHAIN_NAME, COMPONENT_NAME, and COMPONENT_MODULE columns as shown below.



Edit the COMPONENT_NAME column and add a prompt.

7. To prompt for an alias name, edit the COMPONENT_NAME column as shown in the example above. In the example above, the following edits were set:
   • The text in the Description field was edited to make a better prompt description.
   • The Prompt box was checked.
   • Character was selected in the Data Type field.
8. You can now test the report by clicking the Show button on the Jobs window.

In the image below, DELDEFAULT is entered as the prompt value. DELDEFAULT is an alias name for the SODELETE job when used in the SYSTEM process flow that ships with Applications Manager.



Respond to the prompt.

Output from the report is shown below.



Report output for the DELDEFAULT alias name.