Do you know about TWS historical reportcli?
Francesco Carteri 120000J0NF Comments (2) Visits (6556)
It's simply to install and simply to use. You can just untar the package and configure some properties files to point to the database.
The command line comes with some templates to extract the historical data. These templates are properties files where to configures the filters for the jobs, workstation, time interval etc.
Documentation link how to run the cli with some templates:
After untar the reportcli image, all the templates available are unde
The reportcli.sh (or reportcli.bat ) is under <REPORTCLI_DIR> and can be run directly on a shell (or command prompt) or can be scheduled with a TWS job (classic or dynamic job, respectively with a FTA or a Dynamic Agent).
When you try to run the reportcli.sh (or reportcli.bat) ensure you are logged on the shell with the user which is the owner of the all directories and files. This is user need to be the same user when you'll shedule a job to run the reportcli.sh.
Basically the reports templates available are one for each report type. Note that some reports in the layout contain charts, other only table.
All reports can be extracted to all the output formats (HTML, PDF, CSV) and the output can be sent via email too.
Run a custom sql report passing your own query on the fly. It extracts all jobs definitions in a file jobdefinitions.pdf into the /tmp dire
Run a job run statistics report:
./reportcli.sh -o /tmp/ -r jobrunstatists -p /opt
An examples of workstation workload summary report: