Re: script to total backups
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 " " 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?
Re: script to total backups
Try this It gives the averages by node for all successful backups in the summary table select entity, avg(bytes) "Avg Bytes", avg(end_time - start_time) "Elapsed" \ from summary \ where activity='BACKUP' \ and failed=0 \ group by entity ENTITY Avg Bytes Elapsed -- - ACC-DATAGATE 25524904.3870967741935 0 00:00:28.516129 ACC-ORA-OTTR 15156238.37500 0 00:00:23.093750 ACC-VIVAS610268.6129032258064 0 00:00:02.483870 AGE-DB1 157714240.0322580645161 0 00:03:08.193548 AGE-TS1 4583265.6 0 00:01:18.90 APP-CSS-TEST 168430789.0 0 00:02:45.66 APP-ORA-OTTR 594944956.0322580645161 0 00:05:24.516129 BNS-EGATE 36893041.96000 0 01:01:11.52 DATAGATE 116945846.4838709677419 0 00:01:31.193548 DBSERVER1 767947664.6129032258064 0 00:16:55.258064 DBSERVERDEV 372793559.2903225806451 0 00:31:36.709677 DCTBURNER 174101649.2 0 00:15:03.20 ERS-CITEC-DC01175674509.3870967741935 0 00:15:41.290322 Merry Xmas Steve Harris AIX and TSM Admin Queensland Health Brisbane Australia >>> " " <[EMAIL PROTECTED]> 21/12/2001 4:51:37 >>> Does anyone have a query that will tell me the average time a backup took and the average amount of data transmitted? ** This e-mail, including any attachments sent with it, is confidential and for the sole use of the intended recipient(s). This confidentiality is not waived or lost if you receive it and you are not the intended recipient(s), or if it is transmitted/ received in error. Any unauthorised use, alteration, disclosure, distribution or review of this e-mail is prohibited. It may be subject to a statutory duty of confidentiality if it relates to health service matters. If you are not the intended recipient(s), or if you have received this e-mail in error, you are asked to immediately notify the sender by telephone or by return e-mail. You should also delete this e-mail message and destroy any hard copies produced. **
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 " " 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?
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?