With TSM3.7 I use Crystal REports to query the SUMMARY table. Query'n the
NODE table gets you only the LAST connection. The SUMMARY table gives you
ALL of them, both backup/archive and restore/retrieve. Also you can get
server process information on storage pool backups, reclamation, migration.
I produce some good reports from this data.

Bill Boyer
DSS, Inc.

> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
> Clarence Beukes
> Sent: Wednesday, March 15, 2000 8:14 AM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: num_in_mb
>
>
> 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
> 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
>
> -----Original Message-----
> From: Clarence Beukes [mailto:clarence AT ZA.IBM DOT COM]
> Sent: 15 March 2000 08:40
> To: ADSM-L AT vm.marist DOT edu
> Subject: num_in_mb
>
>
> I backup +/- 50 servers per night. Is there an SQL query that will tell me
> how data(in mb) was sent by each server. This will help to to check the
> total amount of data backed up daily.
>
> Thanks in advance!!
>
>   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. "
>