You could write an SQL to go against the "contents" table which includes
columns for volume name, node name, file space name and file name.

Thank You,

Stefan Dusedau
infoWorks
A Viacom technology service
(212)258-6739
stefan.dusedau AT viacom DOT com <mailto:stefan.dusedau AT viacom DOT com>


        -----Original Message-----
        From:   Guntis Liepins [mailto:GLiepin1 AT EXCHANGE.TELEKOM DOT LV]
        Sent:   Monday, February 01, 1999 11:42 AM
        To:     ADSM-L AT VM.MARIST DOT EDU
        Subject:        How to predict which tapes will be mounted during
restore

        Hi ADSM gurus!

        Is it posible to predict which tapes will be mounted during restore
        operation ?
        ( I need to make a list of tapes,to bring the tapes from the secure
offsite
        archive,and
        load them into 3494 library)
        Currently ,the only way is to set library mountwait to 1 sec,run the
ADSM
        restore script
        file by file and watch in the actlog for the tape mount requests.
It is a
        _very_ slow way and this
        has a serios impact to the library (3494) operation and can cause
some
        backup to fail
        during this operation. Btw,it seems that if file is split between
two tapes
        error log will show
        me only the first tape.
        This way is ok if I need to restore a few files. But if I have a
several
        thousands of files ,archived
        for several years,few thousands of tapes stored partially in the
library and
        partially offsite
        this is a nightmare. ADSM must keep the information where the files
are
        stored
        somewhere in his internal database,isn't it ? I simply *could* *not*
        *believe* that there are no
        smarter and easier way like to predict which tapes is necessary for
restore.
        Please answer me - is it possible or not ?

        P.S. If the q content could display not only a filename ,but also an
arhive
        description,it could be
        a solution. Unfortunately it can't do this.


        ------------------------------------------------------
        Guntis Liepins

        Systems administrator ,LATTELEKOM SIA
        tel. (+371) 7224199 mob. (+371) 9240376
        -------------------------------------------------------