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
[EMAIL PROTECTED]
(973) 948-1306
-----Original Message-----
From: David E Ehresman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 15, 2003 1:41 PM
To: [EMAIL PROTECTED]
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
