This can be done by creating a perl script using findObjects. If you run the command
ectool findObjects job, it will output a list of every job that has executed with the values of each job's properties. You can filter the jobs by property by creating perl scripts.
NOTE: These scripts must be converted from .txt to .pl due to .pl files being unsupported on ask.
I have attached a script jobs.txt that only outputs the jobs with 'outcome' equals 'error'. You can run this script with the command
ec-perl jobs.pl. The output can be redirected into a file for further analysis.
The output of this script will be in xml format. If you want to import this data into Excel, you must format the data as csv. I have attached a script format.txt that takes in a file 'jobs.xml' and outputs every job's ID, name, and finish date, separated by a semicolon and on a new line for each entry. The output is stored in 'report.csv'. You can execute the script by running
You can use these scripts as a template to modify further to fit your needs.