You can also start the session with -virtualnodename.  It works with dsmc or 
dsmj, and avoids the need for the proxy setting.

Jim Schneider
Essendant

-----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 9:30 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: [ADSM-L] SQL QUERY FOR AMOUNT OF ACTIVE VS INACTIVE DATA

You can also GRANT PROXY and then use -ASNODE from one of your own nodes, using 
your node's password. I think the general node type has to match (i.e. any UNIX 
can proxy to any UNIX, but not Windows).

On Fri, Apr 22, 2016 at 02:20:38PM +0000, Schneider, Jim wrote:
> 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.

--
-- 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