How to create a Control-M Report to show job attributes of a specific job type such as SAP, Databases, etc.? I want to run a report that shows all jobs that are configured for a specific job type such as Control-M for SAP or Control-M for Databases. When using a "Job Definitions" report in Control-M Reports, I do not see columns that show parameters for specific job types, for example a column for the "What:" section that contains connection profiles and their details. Here are examples of job attributes not seen in the Job Definitions report. Control-M for Databases: Connection Profile FileWatcher: Time Limit SAP Business Objects: Instance Title |
Run a report to find these parameters using the "Job Definitions - Variables" report. For each job type, the unique parameters are stored as internal Control-M Variables. These can be seen in job/folder XML exports from the Planning Domain. Run a report on the job type to determine all the variables it uses. For example, to run a report that shows all FileWatcher jobs that have a "Time Limit" value of 5, use the following steps: 1. Launch Control-M Reports and open a "Job Definitions - Variables" report.
2. Add a filter that will show only 1 FileWatcher job. You can use a filter like "Job Name - Is - <JobName>". This job should have a "Time Limit" value of 5. 3. Run the report. You should now be able to see all the variables that the specific job type is using. 4. In the report, look in the "Variable Value" column and find the row with a value of 5. 5. In the same row, note down the value in the "Variable Name". For a FileWatcher job, the "Time Limit" variable is %%FileWatch-TIME_LIMIT. 6. Remove all filters on the report 7. Add the two following filters Variable Name - Is - %%FileWatch-TIME_LIMIT
Variable Value - Is - 5 8. Run the report
Using the steps above, this will generate a report of all FileWatcher jobs that have a "Time Limit" of 5. These same steps can be applied to find the variables used for any job type, and you can then use the variable/value to filter for the jobs you want. In general, the steps are as follows: 1. Use the "Job Definitions - Variables" report against a specific job type to find all the variables it uses.
2. Take note of the variable name you want to filter on. 3. Use the filters "Variable Name" and "Variable Value" to find the jobs that you are looking for. Another option is to filter in the report for something like the following: Variable Name Like %%SAPR3* This will list all jobs that have a Control-M for SAP job attribute for example. From there, export the report to CSV and manipulate the data to view as desired in Microsoft Excel The following video demonstrates this solution: |