ADSM-L

Question - How can Icount files and MB currently under ADSM/TSM?

2000-02-21 16:09:20
Subject: Question - How can Icount files and MB currently under ADSM/TSM?
From: Gary Ison <Gary.Ison AT MAIL.STATE.KY DOT US>
Date: Mon, 21 Feb 2000 16:09:20 -0500
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>
<Prev in Thread] Current Thread [Next in Thread>
  • Question - How can Icount files and MB currently under ADSM/TSM?, Gary Ison <=