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>
|