Why not simply use q nodedata <nodename> - that will give all the volumes in all storage pools that contain data for the node. You can subset this to q nodedata <nodename> stg=<storage pool name> so that you get only the volumes in the storage pool in question that contain data for the node of interest.
Regards, Joerg Pohlmann -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of Paul Fielding Sent: Wednesday, June 29, 2011 15:49 To: [email protected] Subject: Re: [ADSM-L] volumes associated with a node Hmmm.... When I do "show volumeusage NODENAME", I get no result, regardless of node.... Paul On Wed, Jun 29, 2011 at 2:49 PM, Shawn Drew < [email protected]> wrote: > I would go with the volumeusage table instead of contents if you just > want the tapes for a node. > select distinct(volume_name) from volumeusage where node_name='NODENAME' > (that will show copypool volumes also) > > Alternatively, there is a show command: > show volumeusage NODENAME > > > Regards, > Shawn > ________________________________________________ > Shawn Drew > > > > > > Internet > [email protected] > > Sent by: [email protected] > 06/29/2011 09:09 AM > Please respond to > [email protected] > > > To > ADSM-L > cc > > Subject > Re: [ADSM-L] volumes associated with a node > > > > > > > select volume_name from contents where node_name like '%nodename%' and > FILESPACE_NAME like '%Filespacename%' and FILE_NAME like '%Filename%' > > On Wed, Jun 29, 2011 at 3:48 PM, molin gregory > <[email protected]>wrote: > > > Hello, > > > > Try : q nodedata NODENAME stg=XXXX > > > > Cordialement, > > Grégory Molin > > Tel : 0141628162 > > [email protected] > > > > -----Message d'origine----- > > De : ADSM: Dist Stor Manager [mailto:[email protected]] De la > > part de Tim Brown Envoyé : mercredi 29 juin 2011 14:40 À : > > [email protected] Objet : [ADSM-L] volumes associated with a node > > > > Is there a select statement that will list all tape volumes that > > have > files > > for > > > > a given TSM node. > > > > > > > > Thanks, > > > > > > > > Tim Brown > > Systems Specialist - Project Leader > > Central Hudson Gas & Electric > > 284 South Ave > > Poughkeepsie, NY 12601 > > Email: [email protected] <<mailto:[email protected]>> > > Phone: 845-486-5643 > > Fax: 845-486-5921 > > Cell: 845-235-4255 > > > > > > > > > > This message contains confidential information and is only for the > intended > > recipient. If the reader of this message is not the intended > > recipient, > or > > an employee or agent responsible for delivering this message to the > intended > > recipient, please notify the sender immediately by replying to this > > note > and > > deleting all copies and attachments. > > > > "ATTENTION. > > > > Ce message et les pièces jointes sont confidentiels et établis à > > l'attention exclusive de leur destinataire (aux adresses spécifiques > > auxquelles il a été adressé). Si vous n'êtes pas le destinataire de > > ce message, vous devez immédiatement en avertir l'expéditeur et > > supprimer > ce > > message et les pièces jointes de votre système. > > > > This message and any attachments are confidential and intended to be > > received only by the addressee. If you are not the intended > > recipient, please notify immediately the sender by reply and delete > > the message and > any > > attachments from your system. " > > > > > > -- > Thanks & Regards, > Sarav > +974-3344-1538 > > There are no secrets to success. It is the result of preparation, hard > work and learning from failure - Colin Powell > > > > This message and any attachments (the "message") is intended solely > for the addressees and is confidential. If you receive this message in > error, please delete it and immediately notify the sender. Any use not > in accord with its purpose, any dissemination or disclosure, either > whole or partial, is prohibited except formal approval. The internet > can not guarantee the integrity of this message. BNP PARIBAS (and its > subsidiaries) shall (will) not therefore be liable for the message if > modified. Please note that certain functions and services for BNP > Paribas may be performed by BNP Paribas RCC, Inc. >
