Forum Discussion

mj100's avatar
mj100
Level 3
10 years ago

OpsCenter SQL query Help

Hi,

Need a little bit of help, need to create a custome report for our DBA team they have a list of policies and want to know when they ran last, is there a query where i can put the list of policies and run a success / failure report to provide them?

 

thanks in advanced for any and all help

 

Backup and Recovery
OpsCenter
Windows Server (2003-2008)
  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    10 years ago

    You could, but you can also just create Views in OpsCenter and add the clients/policies to them. Then run the report on the View. Either way, I would create the View, because you can base your SQL query on the view as well.

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    10 years ago

    Hi,

     

    You don't need a query for that its quite simple and covered by the "canned" reports available in OpsCenter.

    Backup Reports > Status and Success Rates

    There should be one that matches your requirement. You can edit it, select the policies/clients you need, then save it as a public  / private report with what ever name you choose. You can then send this to DBA's

     

  • mj100's avatar
    mj100
    Level 3
    10 years ago

    Riaan,

    thanks for the information I have looked at this option however we are talking about hundreds of policies at multiple sites, it would be much easier to maintain a list and run an SQL query against it. Any other thoughts.

     

    thx

  • RiaanBadenhorst's avatar
    RiaanBadenhorst
    Level 6
    10 years ago

    You could, but you can also just create Views in OpsCenter and add the clients/policies to them. Then run the report on the View. Either way, I would create the View, because you can base your SQL query on the view as well.