Thanks for all the help.....
I came up with a select statement:

adsm>  select node_name,lastsess_recvd as num_of_bytes,lastacc_time from
nodes order by 2 desc

this is the output...

NODE_NAME                      NUM_OF_BYTES                   LASTACC_TIME
---------------------          ----------------------------
----------------------------------------
----------------------------------------
CIOTMS                                      3739514469
CIOTMS                                      3739514469
2000-03-15 10:24:43.000000
SDPODB                                      992092159
2000-03-15  06:57:19.000000


  GOD Bless
   Clarence Beukes
   IT Specialist (ADSM/TSM)
   IBM Intergrated Technology Services
   Tel : +2711 302 5333   Fax : +2711 302 8209
   Mobile : +2782 573 5665

"A computer is almost human - except that it does not blame its mistakes on
another computer. "


"Jordan, Chris (ELS)" <c.jordan AT ELSEVIER.CO DOT UK> on 03/15/2000 12:27:25 PM

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

To:   ADSM-L AT VM.MARIST DOT EDU
cc:    (bcc: Clarence Beukes/South Africa/IBM)
Subject:  Re: num_in_mb




Its not SQL, but you can query the Activity Log for "Bytes Trans", and this
will list all the individual clients and how much data each one sent. Paste
this into Notepad, and save the .TXT file. Open the .TXT file in Excel
delimited by space, and sum the required column.

Paste the result into another Excel spreadsheet that maintains the amount
of
data backed up per day.

Cheers, Chris