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.
