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.51ACC-DATAGATE                   25524904.3870967741935         0 
00:00:28.516129
ACC-ORA-OTTR                   15156238.3750000000000         0 00:00:23.093750
ACC-VIVAS                        610268.6129032258064         0 00:00:02.483870
AGE-DB1                       157714240.0322580645161         0 00:03:08.193548
AGE-TS1                         4583265.6666666666666         0 00:01:18.900000
APP-CSS-TEST                  168430789.0000000000000         0 00:02:45.666666
APP-ORA-OTTR                  594944956.0322580645161         0 00:05:24.516129
BNS-EGATE                      36893041.9600000000000         0 01:01:11.520000
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.2000000000000         0 00:15:03.200000
ERS-CITEC-DC01                175674509.3870967741935         0 00:15:41.290322

Merry Xmas

Steve Harris
AIX and TSM Admin
Queensland Health
Brisbane Australia


>>> "<James> <healy>" <James.Healy2 AT AXACS DOT COM> 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.
**********************************************************************