Use a server you can access and modify the nodename in the options file, 
assuming you know the password.

Jim Schneider
Essendant

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

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

**********************************************************************
Information contained in this e-mail message and in any attachments thereto is 
confidential. If you are not the intended recipient, please destroy this 
message, delete any copies held on your systems, notify the sender immediately, 
and refrain from using or disclosing all or any part of its content to any 
other person.