Re: script to total backups
2001-12-20 18:15:08
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?
|
|
|