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