Hello David. I use this script to get a list of tapes. It is not perfect
because it gets tapes with inactive files as well as active files but it is
fairly quick. Usually under 5 minutes or so which is not too bad considering
how much data it has to wade through!


Usage: RUN BRSLIST SERVERNAME STGPOOLNAME i.e. 'Run brslist FS010 COPYVAULT'
- Server and stgpool must be UPPER CASE.


Name           Line       Command

               Number
----------     ------
------------------------------------------------------------
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


     Take care,
         Al


Alan Davenport
Senior Storage Administrator
Selective Insurance Co. of America
alan.davenport AT selective DOT com
(973) 948-1306


-----Original Message-----
From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU]
Sent: Wednesday, January 15, 2003 1:41 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: To Collate or Not to Collate? - UPDATE


> Since then I've been
>able to put an SQL query together to get that info but it takes quite
a
>while to execute.

Can you share that code with us?

David