Thanks, I can get the occupancy for the filespaces; I am trying to get an actual list of inactive directory folders from the client and how much data they contain.
I am currently using this query from the client: dsmc q backup -subdir=yes -inactive "\\location\foldername\*.*" > c:\output.txt These are all top level user directories that I am getting manually and then manually querying for content and summarizing for the amount of data. I am looking for a better method to collect this. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:ads...@vm.marist.edu] On Behalf Of Remco Post Sent: Friday, March 26, 2010 10:36 AM To: ADSM-L@VM.MARIST.EDU Subject: Re: [ADSM-L] Query for inactive data summary Just ignore Lindsay, he doesn't even know the correct syntax for an URL :) select node_name,filespace_name,capacity,pct_util from filespaces where backup_start<current_timestamp-30 days you could possibly join against the occupancy table, slowing things down to a crawl :) (and yes, there are reporting tools that can do this for you outside the TSM database) On 26 mrt 2010, at 15:35, Lindsay Morris wrote: > Debbie, I think the new storage reports on our ART product will help you: > http:downloads.tsmworks.com/ARTProductDemo.ppt, slides 27-29. > -------------------- > Lindsay Morris > CEO, TSMworks > Tel. 1-859-539-9900 > lind...@tsmworks.com > > > On Fri, Mar 26, 2010 at 10:26 AM, Haberstroh, Debbie (IT) < > habe...@voughtaircraft.com> wrote: > >> Good morning, >> >> >> >> We have a lot of old inactive folders that I would like to delete but I >> need to gather some information to present to my customer before I can >> do this. I am looking for a query that will summarize the data, just >> the inactive folder name and amount of data in it. I can do the dsmc q >> backup and get a list of all of the files in the folder but was looking >> for a query that would consolidate the information before going for all >> of the detail. If someone could point me in the right direction I would >> appreciate it. >> >> >> >> We are running TSM 5.5 and our reto policy is no limit, thanks. >> >> >> >> Debbie Haberstroh >> >> Server Support >> >> >> -- Met vriendelijke groeten/Kind regards, Remco Post r.p...@plcs.nl