UNSOLVED

kclebak

updated

14 years ago

K

kclebak

31 Posts

0

1120

May 17th, 2012 06:00

Calculating the actual backup window

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