Calculating the actual backup window

Question

We are using DPA in conjunction with Avamar. I am attempting to take the standard Job Summary report and add a column that shows the effective backup window. By effective backup window I mean taking the latest time that a job completed and subtracting the earliest time that a job started.

I tried brining in the Backup Job Details Source twice. Once trying to use the Minimum Opertator against the start time field and then using the Maximum Operator against the end time field. I then just figured I could use the Subtract Fields Operator to subtract the two. I do not believe, from reading the help file, that the Minimum and Maximum operators can be run against a date field.

I was hoping that someone might have another idea on how to accomplish this.

I know there is a report that shows the backup window duration, but that is simply just adding up the running times of all the individual jobs. I want to be able to say if my first job stated at 8:00PM and another given job ended at the latest time of 5:00AM, the my backup window was 9 Hours.

Thanks in Advance

ElvinKan · Answer

Hi kclebak

The standard report that comes to mind is the “Backup Job Schedule” (Scheduling -> Job Schedule) which shows a gantt chart of when it job ran and you can hover over each to get the details.

For your question, I would use the Extended Job Rollup operator – and Rollup by Client – assuming you want to look at all the jobs per Client in that window ie. get the earliest start job of the first job and use the end time of the last job.

HTH

-E

kclebak · Answer

I actually found a different way to accomplish this task.  I was able to bring in the Backup Job Details twice.  Once ordering by Start Time in Ascending order and keeping only the first record.  Secondly ordering by End Time in Descending order and keeping only the first record.  I could then Merge and Finally Subtract the fields.

Data Protection Advisor

Calculating the actual backup window

Was this post helpful?