Previous Topic: How to Create and Run a Batch Reporting JobNext Topic: Run the Batch Reporting Job

Manage Data and Objects › How to Create and Run a Batch Reporting Job › Create a Batch Reporting Job

Create a Batch Reporting Job

The Investigator helps you view and analyze information stored in discipline-specific data repositories by providing multiple work areas (panes) to help you manage your data.

In this example, you use the Investigator to create a list of suspended users, which auditors requested. You then save the search queries behind this list to a z/OS PDS member with the click of an icon. After you save them, the Investigator adds JCL statements to create a batch job that you can submit to generate a report.

Follow these steps:

  1. Log in to CA Chorus with security discipline access.
  2. Add the Investigator module to your workspace, and click Start New Investigation.
  3. Select Security from the discipline drop-down list.
  4. Select Definitions, Users.

    The list of users appears in the Investigator.

  5. Click the View Filter icon, if the search panel is not loaded.
  6. Specify Suspended (password) =Y as your filter criteria to identify the suspended users, and click Search.

    Note: Narrow your search by adding criteria.

    A list of users suspended for password violations appears in the Investigator.

  7. (Optional) Customize the tabular view:
    1. Add or remove columns from the table by clicking the wrench icon in the Investigator toolbar and editing the All Selected Columns in Select and Reorder Columns dialog. In this example, the security administrator adds the Number of Password Violations column.
    2. Click Save.

    The column settings are saved for this view.

  8. Save the search query as a JCL batch job:
    1. Click the Save search queries icon, and select Save JCL from the pop-up menu.
    2. Enter the following information:
      • (Optional) The name of the data set and member containing the JCL template to apply to the job. Enter this name when only more than one template is available. The default is your_chorus_runtime.CETJEZTR(EZTMPL01).
      • The name of a data set and member name to save the JCL batch job to.
      • A description of the batch job being saved (for example, "Quarterly Suspended ID Report").
    3. Click Yes.
    4. Click OK in response to the successful save message.

    Note: You can also save the search query as an Investigator query by clicking the Save search queries icon and selecting Save Query. This feature saves you from creating the query each time that you want to view the information in the Investigator. Also, you can export the list of suspended users that currently appear in Investigator by clicking the Export icon.

    The Investigator saves the batch job to the specified data set. This job consists of search queries and JCL statements. In our example, you now have a list of suspended users for the quarter.