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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Remco Post
Sent: Friday, March 26, 2010 10:36 AM
To: ADSM-L AT VM.MARIST DOT 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
> lindsay AT tsmworks DOT com
> 
> 
> On Fri, Mar 26, 2010 at 10:26 AM, Haberstroh, Debbie (IT) <
> HABERDE AT voughtaircraft DOT 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.post AT plcs DOT nl