This will give you average backup stats for the last 14 days. SELECT entity as node, avg(end_time-start_time) as elapsed_time, avg(cast((bytes/1024/1024) as decimal(18,0))) as MB from summary WHERE activity='BACKUP' and examined<>0 and DAYS(CURRENT_TIMESTAMP) -DAYS(start_time) < 15 GROUP BY entity
John Monahan Senior Consultant Enterprise Solutions Computech Resources, Inc. Office: 952-833-0930 ext 109 Cell: 952-484-5435 http://www.compures.com "<James> <healy>" Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> 12/20/2001 12:51 PM Please respond to "ADSM: Dist Stor Manager" To: [EMAIL PROTECTED] cc: Subject: script to total backups Does anyone have a query that will tell me the average time a backup took and the average amount of data transmitted?
