login Signup

How to generate a list of all failed jobs in ElectricFlow?

I would like to create a report of all failed jobs and import it into an Excel spreadsheet. Is there any way of generating a list of only failed jobs?

avatar image By hchu 30 asked Mar 06, 2018 at 06:16 PM
more ▼
(comments are locked)
10|750 characters needed characters left

1 answer: sort voted first

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 ec-perl format.pl

You can use these scripts as a template to modify further to fit your needs.

jobs.txt (428 B)
format.txt (800 B)
avatar image By hchu 30 answered Mar 13, 2018 at 11:40 PM
more ▼
(comments are locked)
10|750 characters needed characters left
Your answer
toggle preview:

Up to 8 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.