11-25-2013 01:55 AM
Hi,
I am new on opscenter queries. I need a report displays only the successful backup job reports last 24 hours. does the anyone have this query ?
11-25-2013 08:27 AM
an easy way is to use existing template and modify it, like this
Report Templates > Backup > Job Browser > Tabular Backup Report
Edit Report > Filters > Job > Job Status = Successful
Add > Run Report
11-25-2013 02:01 PM
Hi wr, thanks for the answer. but is that report show the all successful backup include main & child job. l just need to only main kob results.
11-25-2013 09:24 PM
11-26-2013 06:49 AM
Hi inn_kam,
thanks for the link. l am able to create customer query but i did not find the how to create only successful main job. when l generate the report l get whole successful backup result and for example my only one oracle backup job has more than 150 stream and in the report l saw all stream result but l need the just a main job result.
11-27-2013 04:11 PM
Probably it's better to use "Advanced report" for that, in this type of report, you can choose the "Metric type" to be Job which will display only the parent/main job, choose Stream if you want to see every job streams (child jobs).
Related technote: http://www.symantec.com/docs/TECH183889