OpsCenter SQL query for custom report

[bsveritas]

Folks,

I need a SQL query to pull out last 24 hours failed job details [client name, Job id, Master server, status code, start time and end time] for SQL policy alone.  Also, total number of jobs ran for SQL policy, Success and failure count. Any help is appreciated.

Thanks

Bhasan

[sdo]

You did say "any help"...

...maybe this super post from @VoropaevPavel

https://vox.veritas.com/t5/Downloads/OpsCenter-common-custom-reports/ta-p/809039