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@VM.MARIST.EDU] On Behalf Of Lee, > Gary > Sent: Friday, April 22, 2016 9:11 AM > To: ADSM-L@VM.MARIST.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@VM.MARIST.EDU] On Behalf Of > Skylar Thompson > Sent: Friday, April 22, 2016 10:00 AM > To: ADSM-L@VM.MARIST.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 (skyl...@u.washington.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 (skyl...@u.washington.edu) -- Genome Sciences Department, System Administrator -- Foege Building S046, (206)-685-7354 -- University of Washington School of Medicine
