OPS Center SQL Query for custom report

[MJaggi]

Hi,

 Can someone help to provide a Ops center SQL query, where I can get report with below columns :

Client Name ; Policy Name ;  Policy Type ; Backup Selection ; Last Good Backup.

[X2 · Accepted solution]

First things first: Search .... before asking.

For the query you want, with the exception of "Backup Selections", you can get started with the report "Last successful backup for failed jobs, done by M_henriksen" on OpsCenter common custom reports and then customize it to your liking. You could possibly use other reports from that page as example to build your query to include backup selections too.

Let us know if you were able to do it and share the query with the community and/or ask questions.