Thanks Steve and John for your assistance with the scripts, they're exactly
what I was looking for.




"John Monahan" <JMonahan AT COMPURES DOT COM>@VM.MARIST.EDU> on 12/20/2001
06:11:16 PM

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
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
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" <ADSM-L AT VM.MARIST DOT EDU>
12/20/2001 12:51 PM
Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        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?