I use this script to gather tapes for DR testing. I think this is what you
want:
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
Name Description
Managing profile
--------------- --------------------------------------------------
--------------------
BRSLIST Usage: RUN BRSLIST SERVERNAME STGPOOLNAME i.e.
'Run brslist FS010 COPYVAULT' - Server and
stgpool must be UPPER CASE.
Take care,
Al
Alan Davenport
Senior Storage Administrator
Selective Insurance
[EMAIL PROTECTED]
(973) 948-1306
-----Original Message-----
From: Zosimo Noriega (ADNOC IS&T) [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 04, 2002 10:39 PM
To: [EMAIL PROTECTED]
Subject: how to identify ofsite tapes for specific node
hi guys,
please help me to identify offsite tapes belong to a specific node. i have
a problem on my onsite tapes for specific node but i could not easily
identify which offsite tapes belong to that node from my offsite location.
Do you have a SQL scripts or commands to get done this tasks?
your help is really appreciated..... thanks,
Zosi Noriega
ADNOC - UAE
