On 29 June 2011 14:09, Saravanan Palanisamy <evergreen.sarav AT gmail DOT 
com>wrote:

> 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
>