Wish I could do that.  This comes from three levels above me in management.
Trying to buy more storage to sell to departments.
Don't ask me, I have no clue what they are doing.

I'll look into the q backup on client side, but don't have access to all of 
them.


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Skylar Thompson
Sent: Friday, April 22, 2016 10:00 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

If you have access to the clients, you can use QUERY BACKUP and parse the
A/I column.

Honestly, though, when we've gotten this query, I've managed to push this
back on the customers; it's not TSM's problem what's active or inactive,
it's the customers' applications that are actually responsible for it.
Obviously you need a pretty good relationship with your customers to make
that case, but in the end it's caused our customers to think more carefully
about workflow in general.

On Fri, Apr 22, 2016 at 01:51:20PM +0000, Lee, Gary wrote:
> Just got a request for the amount of active versus inactive data on our tsm 
> servers.
>
> Is there a better way than traversing the backups table and summing?
> That would be a mighty long query.
>
> We have three servers, and approximately 300 clients about 200 tB total data.
>
> Thanks for any suggestions.

--
-- Skylar Thompson (skylar2 AT u.washington DOT edu)
-- Genome Sciences Department, System Administrator
-- Foege Building S046, (206)-685-7354
-- University of Washington School of Medicine