I use this script to gather tapes for DR testing. I think this is what you
want:


Name           Line       Command

               Number
----------     ------
------------------------------------------------------------
------------------------------------------------------------
BRSLIST        1          select volume_name,status from volumes where
BRSLIST        1          select volume_name,status from volumes where
volume_name in
                           (select volume_name from volumeusage where

                           node_name='$1'and stgpool_name='$2') order by

                           status,volume_name


Name                Description
Managing profile
---------------     --------------------------------------------------
--------------------
--------------------
BRSLIST             Usage: RUN BRSLIST SERVERNAME STGPOOLNAME i.e.
BRSLIST             Usage: RUN BRSLIST SERVERNAME STGPOOLNAME i.e.

                     'Run brslist FS010 COPYVAULT' - Server and

                     stgpool must be UPPER CASE.


   Take care,
       Al

Alan Davenport
Senior Storage Administrator
Selective Insurance
alan.davenport AT selectvie DOT com
(973) 948-1306