Thanks Steve and John for your assistance with the scripts, they're exactly what I was looking for.
"John Monahan" <[EMAIL PROTECTED]>@VM.MARIST.EDU> on 12/20/2001 06:11:16 PM Please respond to "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] cc: Subject: Re: script to total backups 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?
