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 <[EMAIL PROTECTED]>: > > 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 >
