select node_name,copy_type,volume_name,stgpool_name from volumeusage where
node_name='NODENAME' group by node_name,copy_type,volume_name,stgpool_name

gives you the node-tapes used relation.

Gr.

-----Oorspronkelijk bericht-----
Van: Gerald Wichmann [mailto:gwichman AT ZANTAZ DOT COM]
Verzonden: dinsdag 26 november 2002 18:03
Aan: ADSM-L AT VM.MARIST DOT EDU
Onderwerp: Re: Querying which volumes have a particular file or node


Not exactly the answer I was looking for..

Gerald Wichmann
Senior Systems Development Engineer
Zantaz, Inc.
925.598.3099 (w)

-----Original Message-----
From: Raghu S [mailto:raghu AT COSMOS.DCMDS.CO DOT IN]
Sent: Monday, November 25, 2002 9:53 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: Querying which volumes have a particular file or node

in Tivoli Storage Resource Manager all these are addressed

raghu.



                    Gerald
                    Wichmann             To:     ADSM-L AT VM.MARIST DOT EDU
                    <gwichman@ZAN        cc:
                    TAZ.COM>             Subject:     Querying which volumes
have a
                    Sent by:             particular file or node
                    "ADSM: Dist
                    Stor Manager"
                    <ADSM-L AT VM DOT MA
                    RIST.EDU>


                    11/26/2002
                    03:25 AM
                    Please
                    respond to
                    "ADSM: Dist
                    Stor Manager"





Given a file with some filenames in it, does someone have a macro/command I
can run against the filenames in that file to determine what volumes those
files are on? I.e. so I can identify which offline volumes I need to put in
my library for a restore before actually running the restore command.

Similarly, given a node, how do I determine what volumes the node has data
backed up to.

I believe both these questions involve a select statement and have been
discussed before so someone should have them handy.

Thanks,
Gerald


This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service.  For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law.  If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent.  Thank you.


This e-mail has been captured and archived by the ZANTAZ Digital Safe(tm)
service.  For more information, visit us at www.zantaz.com.
IMPORTANT: This electronic mail message is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is privileged, confidential or exempt from disclosure under applicable
law.  If the reader of this message is not the intended recipient, or the
employee or agent responsible for delivering this message to the intended
recipient, you are hereby notified that any dissemination, distribution or
copying of this communication is strictly prohibited.  If you have received
this communication in error, please notify the sender immediately by
telephone or directly reply to the original message(s) sent.  Thank you.