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

OCA reporting for Time taken to protect client

Created: 10 Jul 2013 • Updated: 21 Aug 2013 | 4 comments
SymGuy-IT's picture
This issue has been solved. See solution.

Dear Experts,

We are trying to get a report from OCA(OpsCenter Analytics) which gives accurate information about average time taken to protect a client. both Full and INCR backups. This will be used to produce to the management after the environment gets additional hardware as Appliance as we are projecting a good performance. The curent NBU and OCA version is 7.0.1. We have tried to derive the job duration report which is available but it "sum" up all the backups ran for a client and produce the result rather than actualy time taken to complete the backup. So in a 24 hours window it shows that the client took 36 hours to complete the backup.

I am really thinking too much but not getting to a good solution for this. Please help me.

Regards,

Operating Systems:

Comments 4 CommentsJump to latest comment

MilesVScott's picture

If you are using a SQL Query you could throw WHERE bytesWritten > 0 if you want to know about the time it takes to write the image.

 

If you want the entire time from job creation to completion specify where parentjobid = jobid.

 

Hope that helps!

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

SOLUTION
MilesVScott's picture

Were you able to figure it out? Or if you want to post what you have so far, I can take a look at it.

If my answer was helpful, please mark as a solution so others can benefit as well.

NBU 7.1.0.3,Win 2k3 Enterprise x64 SP2

Miles Scott | Holland & Knight
IT Infrastructure Specialist

RonCaplinger's picture

FYI, I just upgraded to 7.5.0.6 and it still reports both full and incremental data together in the same report, ignoring whatever you select for the Schedule Level/Type.

SymGuy-IT's picture

Hey Scott... sorry for being unresponsive. I will surely discuss with you about this later.