Forum Discussion

MJaggi's avatar
MJaggi
Level 3
8 years ago

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.

Ops center query
OpsCenter Analytics
  • X2's avatar
    X2
    8 years ago

    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.

1 Reply

Sort By
  • X2's avatar
    X2
    Moderator
    8 years ago

    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.