Robin,

thanks, this is what I was afraid of...

and yes I would like to see that Perl script.

Also if anyone has some other way of finding this info? ( select statement ?)

Stan




Robin Sharpe <Robin_Sharpe AT BERLEX DOT COM>@VM.MARIST.EDU> on 25/07/2001 
15:25:55

Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Sent by:  "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To:   ADSM-L AT VM.MARIST DOT EDU
cc:
Subject:  Re: Tape volume list ?


Can't do it with a single command.  TSM's volume management is spread
across several tables.  Try these:

q vol f=d
q libvol <libname> f=d
q media f=d
q drmedia f=d (if you are using DRM)
q volhist f=d

There will be many overlaps... for example, private volumes in the library
will normally be in the volumes, libvolumes, and media tables.  Scratch
volumes in the library will only be in the libvolumes table (unless they
were used in the past, then they may be in the volhistory table).  I have a
perl script that creates a html table containing all of this info, if
anyone is interested.

Robin Sharpe
Berlex Laboratories




                    Richard Sims
                    <rbs AT BU DOT EDU>
                                  To:    ADSM-L AT VM.MARIST DOT EDU
                    07/25/01      cc:    (bcc: Robin Sharpe/WA/USR/SHG)
                    09:02 AM      Subject:
                    Please               Re: Tape volume list ?
                    respond to
                    "ADSM: Dist
                    Stor Manager"







>Does anyone know of a way to have a list of all tape volumes known to the
>server?
>
>I mean not only the tape volumes in the library , but also the ones stored
>offsite, on the scratch rack,...

Stan - You may find  Query MEDia STGpool=* [Format=Detailed]
       to be of use.

  Richard Sims, BU