Customize Tivoli Workload Scheduler reports

Create a report task to customize and generate Tivoli Workload Scheduler reports, which you can then view, print, and save, in different kinds of output. Reports help you in many business-related activities, such as:

Tuning the workload on the workstations

Workstation Workload Summary
Workstation Workload Runtimes

Extract detailed information about the plan

Planned Production Details
Actual Production Details

Detect jobs with exceptions

Job Run History
Job Run Statistics

The following table shows the available reports and their details.

Table 1. Report types
Report Name	Description	Output
Job Run History	Collects the historical job run data during a specified time interval. Use it to detect which jobs ended in error or were late. It also shows which jobs missed their deadline, long duration jobs, and rerun indicators for reruns.	Available in table format only. It can be HTML or CSV.
Job Run Statistics	Collects the job run statistics. Use it to detect success, error rates; minimum, maximum, and average duration; late and long duration statistics.	Available in graphic and table formats. It can be HTML or CSV.
Workstation Workload Summary	Shows the workload on the specified workstations. The workload is expressed in terms of number of jobs that ran on them. It helps for capacity planning adjustments (workload modelling and workstation tuning).	Available in graphic and table formats. It can be HTML or CSV.
Workstation Workload Runtimes	Shows job run times and duration on the specified workstations. It helps for capacity planning adjustments (workload modelling and workstation tuning).	Available in graphic and table formats. It can be HTML or CSV.
Custom SQL	Allows you to create reports that best fit your business needs. You can specify an SQL query or import SQL scripts.	Available in table format only. It can be HTML or CSV.
Planned Production Details	Extracts information about planned production plans into either an XML or a CSV format, to be used respectively, with Microsoft Project and Microsoft Excel. This also allows users who do not know Tivoli Workload Scheduler to access plan information in a familiar format.	Available in CSV or XML format only.
Actual Production Details	Extracts current plan information into either an XML or a CSV format, to be used, respectively, with Microsoft Project and Microsoft Excel. This also allows users who do not know Tivoli Workload Scheduler to access plan information in a familiar format.	Available in CSV or Microsoft Project format only.

The output of historical reports, which is extracted from the database, consists of the following main sections. The output of a Planned and Actual report is not structured because it is a file that must be opened with an external program.

Report header

Contains the report title, description, engine name, engine type, creation time, type, and the total number of the result set extracted.

Report of content

Contains a set of hyper-links to each section and subsection.

Report format

Depending on the kind of information you are processing, you can choose to view it in the most appropriate format. The report output can be in:

Table format: It shows information organized in rows and columns, in a CSV or HTML file.
Graphical format (HTML): If you choose the graphical formats, depending on the report type, and on the information you choose to include, you can have data displayed in pie charts, bar charts, line charts, or tables.

Note: To see report output correctly, make sure that you configure your browser as follows:

Allow pop-up windows.
Remove any optional browser toolbar that you installed, if its settings prevent new windows from opening.
To see CSV reports, configure the browser security settings to automatically prompt for file downloads.