You could try something like this:

select volume_name
       from volumes
       where volume_name in
       (select distinct volume_name
               from contents
               where node_name='STORMAN')
       and stgpool_name='COPYPOOL'
       and access='OFFSITE'

(This is one long command that I put
on multiple lines for readability.)

Notes:

You will need to change COPYPOOL to whatever
  your offsite storage pool is.
You will need to change STORMAN to whatever
  node name you are interested in.
The values in single quotes must be in upper
  case, as I have depicted.
If the volumes in the volume name column wrap
  (i.e. if the volume names are greater than 18
  characters), you can extend the column width
  like this:

   select volume_name
          as "VOLUME NAME                        "
          from volumes
          ... etc.

Hope this helps,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.



hi guys,
please help me to identify offsite tapes belong to a specific node.  i
have
a problem on my onsite tapes for specific node but i could not easily
identify which offsite tapes belong to that node from my offsite location.
Do you have a SQL scripts or commands to get done this tasks?

your help is really appreciated.....  thanks,

Zosi Noriega
ADNOC - UAE