Avy, it could be something like:

select date(start_time) date,schedule_name schedule,entity node,(end_time -
start_time) duration from summary where end_time >= current_timestamp - 5
days and activity='BACKUP' and schedule_name='DRP_DAILY_INC_UNIX' order by
3,4

Change my schedule_name 'DRP_DAILY_INC_UNIX' and use your.

WBR
Gabriel Peter

2007/12/7, Avy Wong <AWong AT mohegansun DOT com>:
>
> Hello,
>       Is there a query I can run to get a total backup time on each node
> that is assigned to one particular schedule ?
> This  will help me decide who took the longest time to complete its back
> up
> and give it its own schedule.
> Thank you in advance.
>
> Avy Wong
> Business Continuity Administrator
> Mohegan Sun
> 1 Mohegan Sun Blvd
> Uncasville, CT 06382
> (860)862-8164
> (cell) (860)961-6976
>