Welcome
Dynamic Workload Console User's Guide
Reporting
Predefined Reports
This topic lists the reports you can generate using the predefined reports section.
Creating a task to
How to create an SQL query report task to run on a distributed environment.

Product requirements
This section contains links to the HCL Workload Automation Product Requirements.
Overview
Best practices
Mobile Applications Userʼs Guide
Dynamic Workload Console User's Guide
- Getting Started
  Information about the installation and configuration.
- Running HCL Workload Automation from a mobile device
  Use your mobile device to easily and quickly interact with your HCL Workload Automation environment.
- Managing users and repositories
  How to configure, change, and share your settings repository and change the DB2 user. How to manage the user settings.
- Configuring High Availability
  How to configure, change, and share your settings repository.
- Customizing your console
  You can customize your console to have just the tasks that you want to access.
- HCL Workload Automation Concepts
  Conceptual information about HCL Workload Automation
- Creating and editing items
- Managing Workload Security
  Managing security settings in your environment by using Dynamic Workload Console.
- Changing user password in the plan
  How you change the user password in the plan.
- Monitoring your environment
- Working with Plans
  The main tasks that involve plans.
- Submitting Workload on Request in Production
  How you can insert jobs or job streams into your workflow at any time.
- Keeping track of changes
  How to keep track of changes in your environment
- Reporting
  - Predefined Reports
    This topic lists the reports you can generate using the predefined reports section.
    - Creating a task to generate a report
      How to generate and run a report task.
    - Creating a task to generate a report
      How to generate and run a report task.
    - Creating a task to generate a report
      How to create and run a report.
    - Creating a task to generate a report
      How to create and run a report.
    - Creating a task to
      How to generate a task.
    - Creating a task to
      How to create an SQL query report task to run on a distributed environment.
  - Personalized Reports
    This topic lists the reports you can generate using the personalized reports created with Business Intelligent Report Tool (BIRT).
- Scenarios
  Scenarios demonstrating practical application of HCL Workload Automation in a business environment.
- Reference
  Reference information to perform the main tasks and activities from the .
- Glossary
AI Data Advisor (AIDA) User's Guide
HCL Workload Automation
Welcome to the HCL Workload Automation documentation, where you can find information about how to install, maintain, and use HCL Workload Automation. The documentation has been updated for HCL Workload Automation Version 10.2.8.
HCL Workload Automation for Z
Welcome to the HCL Workload Automation for Z documentation, where you can find information about how to install, maintain, and use the product. The documentation has been updated for version 10.2 Fix Pack 5.
Messages and Codes
Glossary
Product library in PDF format
Notices

Creating a task to

How to create an SQL query report task to run on a distributed environment.

About this task

Use this task to define your own reports by writing or importing SQL queries for extracting data in HTML or CSV format. To create an SQL report task, perform the following steps:

Procedure

From the navigation toolbar, click Monitoring and Reporting > > Manage Predefined Reports, and click Create.
In the Task Information panel, from the Report type drop-down menu, select Report.
In the Report Header panel, choose the name and the format of the output of the report and click Next to proceed or Finish to complete the task creation using all the default values. The Report supports only the Tables View in either HTML or CSV format.
In the Filter Criteria panel, enter the SQL statement on which you want to base your report. You can write the query in the text pane or load an existing query from a file by browsing to the required file and clicking Load. Click Next to proceed or Finish to complete the task creation using all the default values.
In the Report Output Content panel, select the job information that you want to display in the report output. After you make your selection click Next to proceed or Finish to complete the task creation using all the default values.

What to do next

Next, run the report. For further details, see Running Dynamic Workload Console reports and batch reports.