Here is the SQL script :
select volume_name,node_name from volumeusage where node_name='$1' group
by volume_name,node_name
Just give the server name as parameter 1
Ruddy Stouder
System Engineer
I.R.I.S.
Rue du Bosquet 10 - Parc Scientifique de Louvain-La-Neuve
B- 1435 Mont-Saint-Guibert
[EMAIL PROTECTED]
http://www.irislink.com
Tel: +32 (0)10 48 75 10 - Fax: +32 (0)10 48 75 40
-----Original Message-----
From: Sharp, Neil (London) [mailto:[EMAIL PROTECTED]]
Sent: jeudi 1 mars 2001 13:44
To: [EMAIL PROTECTED]
Subject: How to find out what tape's a client data are on ?
I have a frustrating situation whereby if I perform a client restore it
may
call a tape from off-site. This tape is then recalled (usually 4 hours)
and
then placed in the library. The restore then continues but then stalls
again
requesting another tape. What I need to find out up front are all the
tapes
that could possibly be requested for the client and recall all tapes. I
can
find this out by running 'q vol client=X' but I have 2000 tapes to
search
and this will take a long time even if scripted . I think that what I
need
is a SQL query. I am running 3.1.2.22 (don't laugh I am upgrading
shortly)
Thanks for your time.
Neil Sharp
Merrill Lynch ADSM/TSM Administrator
Work : 020-7573-0469
Mobile : 07769-741612
Pager : 01893-038277
e-mail : [EMAIL PROTECTED]
