ADSM-L

Re: script to total backups

2001-12-20 18:15:08
Subject: Re: script to total backups
From: John Monahan <JMonahan AT COMPURES DOT COM>
Date: Thu, 20 Dec 2001 17:11:16 -0600
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?
<Prev in Thread] Current Thread [Next in Thread>