11-10-2015 05:10 PM
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
Solved! Go to Solution.
11-12-2015 08:22 AM
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.
11-12-2015 04:08 AM
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
11-12-2015 07:24 AM
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
11-12-2015 08:22 AM
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.