cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

OPS Center SQL Query for custom report

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.

Tags (1)
1 Solution

Accepted Solutions
Highlighted
Accepted Solution!

Re: OPS Center SQL Query for custom report

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.

View solution in original post

1 Reply
Highlighted
Accepted Solution!

Re: OPS Center SQL Query for custom report

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.

View solution in original post