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
|