Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Need Help in Symantec OPS Center Reports -

Created: 18 Mar 2013 • Updated: 18 Mar 2013 | 3 comments

Hi All,

 

We are looking for a below kind of report from the Symantec OPS Center. Can any one please suggest the steps to pull such report. Seems there is some possibliity from SQL Queries. If there is the chance , can you please provide the same. We have this report to pull for less than 10 clients. Thanks for your help.

 

 

Date Client  Backup Status Size of Backup Tape (or) Disk Backup Selections Count of Skipped files
18-03-2013 XYZ Success 1000G Disk ALL_LOCAL_DRIVES 4
17-03-2013 XYZ Fail 0G      
16-03-2013 netapp1 Success 900G Tape /vol/Vol1 , /vol/vol2 0

 

Regards,

Satish

Operating Systems:

Comments 3 CommentsJump to latest comment

Mark_Solutions's picture

I still dont know if you can pull a report from OpsCenter that gives the backup path - that is always the tricky one

I run this type for a managed customer daily and use the bpdbjobs -report option and then run a vb script against the output to extract the appropriate columns which gives a neat csv output file

Hope this helps

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.

satish.kumar@autodesk.com's picture

Hi Mark,

 

Thanks for your reply. Can you please let me whether bpdbjobs -report can hold the week back raw data and also prints all attributes including backup selections & skipped files too. Can you please give me the full  length command you are using.. So I will try to make out a CGI script and try to manipulate raw data to HTML format. Many Thanks for your help.

 

Regards,

Satish

 

Mark_Solutions's picture

The command extracts what ever is actually in activity monitor - so if you want a longer period just increase how long jobs are held in activity monitor.

As we do not want to include some columns we edit the registry key on the Master (we are on Windows) according to this tech note:

http://www.symantec.com/docs/TECH46268

I run bpdbjobs -report -all_columns and pipe that out to a text file.

I then run a vbs script against that (it is pretty big!) to extract array fields from it, selecting the ones i want (just run the command and take a look at what it gives you then count along the columns to get the field numbers you want - since 7.0 it gives a lot more so we actually take a lot more than we used to have so that we do capture everything) - the results are piped out to a csv file with a , between each value so that it opens nicely in excel

Finally we have a macro in excel that reads the columns and cleans out the rubbish (a lot of SET SNAP etc. gets into the files list due to snapshots these days - you will see what i mean if you look at the file list of a job that does snapshots, like exchange 2010)

This sounds a lot but the command and vbs parts are done in a single batch file (i have also added prompts for first and last job id to analyse so that a range can be selected) after which it is opened with the excel macro and out pops the final result.

We do this every day for 6 NetBackup Domains and all done in a pretty short space of time.

Hope this helps

Authorised Symantec Consultant

Don't forget to "Mark as Solution" if someones advice has solved your issue - and please bring back the Thumbs Up!!.