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
evergreen.sarav AT GMAIL DOT COM

Sent by: ADSM-L AT VM.MARIST DOT EDU
06/29/2011 09:09 AM
Please respond to
ADSM-L AT VM.MARIST DOT EDU


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 
<gregory.molin AT afnor DOT org>wrote:

> Hello,
>
> Try : q nodedata NODENAME stg=XXXX
>
> Cordialement,
> Grégory Molin
> Tel : 0141628162
> gregory.molin AT afnor DOT org
>
> -----Message d'origine-----
> De : ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] De la part 
> de
> Tim Brown
> Envoyé : mercredi 29 juin 2011 14:40
> À : ADSM-L AT VM.MARIST DOT EDU
> 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: tbrown AT cenhud DOT com <<mailto:tbrown AT cenhud DOT com>>
> 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.