Here is a macro I use to do this.  Cut and paste it to a file, then in an
admin commandline client say --

macro <path>\<your-file-name> 'NODENAME-IN-CAPS'

- - begin macro - - -
/*                                              */
/* macro file to select the volumes that a node */
/* is stored on.                                */
/*                                              */
set sqldatetimeformat i
set sqldisplaymode w
set sqlmathmode r
commit
select distinct copy_type, left(node_name,16), left(volume_name,16) -
   from adsm.volumeusage  -
   where node_name = %1 -
     and copy_type in ('BACKUP', 'ARCHIVE') -
     and filespace_name like '%' -
     and stgpool_name = '9840APOOL' -
     >> e:\adsmcv3\sqllists\voluse3
- - end macro - - -

Adjust the stgpool_name or change it to
     and stgpool_name like '%', and change the redirection file name
(the last line).

--
--------------------------
--------------------------
Bill Colwell
Bill Colwell
C. S. Draper Lab
Cambridge, Ma.
bcolwell AT draper DOT com
--------------------------
In <85256889.005BD553.00 AT loudom1.humana DOT com>, on 02/18/00
In <85256889.005BD553.00 AT loudom1.humana DOT com>, on 02/18/00
   at 12:35 PM, "David Browne." <dbrowne AT HUMANA DOT COM> said:

>We had a situation where we had to restore a large  production server.
>This involved multiple tape mounts to rebuild
>the server. We have a large external tape library and multiple tape
>drives which are in STK silo's. Some of the
>tapes are in the silos and others are filed outside
>in a racked tape library. My question is, is there a
>way to get a picking list of tapes needed for the restore
>prior to the start of the restore. It would be
>a big time saver to stage the tapes or enter
>the tapes in the silo's before the tape is called
>to be mounted.
>I know this was not easily done with ADSM, however we have
>recently installed TSM 3.7.1 and was wondering if enhancements have been
>made to enable you to do this with Tivoli Storage manager.