Here is a SQL command I use every month which reports on the amount of data
stored (in MB) and the number of files backed up by ADSM per server:

select node_name, sum(logical_mb) as Data_In_MB, sum(num_files) as
Num_of_files
from occupancy group by node_name order by node_name asc

I would then download the data to your PC and using Excel (or whatever other
tool you like) you can sum up the total.

I stored the data in Microsoft Access so I track the usage of ADSM per
server on a monthly basis.

Frank Mauro
 Liberty Mutual
 COS - ADSM
 Frank.MauroJr AT LibertyMutual DOT com
 603.245.3207


        -----Original Message-----
        From:   Gary Ison [SMTP:Gary.Ison AT MAIL.STATE.KY DOT US]
        Sent:   Monday, February 21, 2000 4:09 PM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        Question - How can Icount files and MB currently
under ADSM/TSM?

        Hello folks,

                I'm trying to determine how many files and how many MB of
storage
        they occupy in two ADSM/TSM servers.  I have the following SQL query
to get
        the information from ADSM/TSM, but the results look a little fishy
to me
        based on the number of clients I have enrolled.  Anyone have a
better
        mousetrap?   Thanks.

        select cast (sum (physical_mb) as decimal(10,0)) -'
                      as "Storage Used", -'
                   cast (sum (num_files) as decimal(10,0)) -'
                      as "Files" -'
                   from occupancy'

                Gary L. Ison
                101 Cold Harbor Drive
                Frankfort, Ky.   40601
                Phone:  (502) 564-8724
                    Fax:  (502) 564-6856
        Gary.Ison AT mail.state.ky DOT us <mailto:Gary.Ison AT mail.state.ky 
DOT us>