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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Paul Fielding
Sent: Wednesday, June 29, 2011 15:49
To: ADSM-L AT VM.MARIST DOT EDU
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 <
shawn.drew AT americas.bnpparibas DOT com> 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
> 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.
>