How do I export Completed Job Stats with scripts?

[Panupat]

Is it possible to use script to generate report CSV files same as what we would get from
Monitor > Tools > View farm report > Completed Job Stats
with custom time range and selective columns?

[cmoore]

Hey Panupat,

Generating reports from DeadlineCommand is covered in this forum post here:

Ways to pull farm statistics from DeadlineCommand

We got a request in on the ticket system, and I thought I’d share the answer here because there are quite a few different ways to pull stats out of DeadlineCommand. The ask was this: I’ve been tasked with finding out of there’s any graceful way of exporting the farm statistics automatically as a monthly report. We added something to DeadlineCommand a little while ago called “FarmReports”. This is going to have a bit more private data in it, so I’ll just post the paramters you can pass in: F…

Regards,

Charles

[Panupat]

hi Cmoore. Thank you for your reply. I’m curious if this FarmReport command was added to Deadline 9 as well? Or only 10.

[Panupat]

Another question. For the flag JobStatistics, is there anyway to wild card the pool/group/plugins parameters?

[eamsler]

The command line is locked in place, but for “JobStatistics” I believe just add empty quotes or omit the flags entirely.

[Panupat]

Ah empty quote works. Cannot omit tho the flags are required.

Thank you.

[Panupat]

Ran into a little problem. The -jobStatistics does not output Job Extra Info which are needed. When adding query with -getJob [id] in the loop, the script run time increased from 4 seconds to almost 15 minutes

Best solution is probably upgrading to Deadline 10 for the -FarmReport command.

[eamsler]

Hmm. How many jobs are in your queue? I can cut a performance ticket for that. It may be worth re-trying the same call on a newer version as well.