Thanks for your help. It has answered my question.

Neil

> -----Original Message-----
> From: Ruddy STOUDER [SMTP:Ruddy.Stouder AT IRISLINK DOT COM]
> Sent: Thursday, March 01, 2001 12:47 PM
> To:   ADSM-L AT VM.MARIST DOT EDU
> Subject:      Re: How to find out what tape's a client data are on ?
>
> 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
> ruddy.stouder AT irislink DOT com
> 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:SharpNei AT EXCHANGE.UK.ML DOT COM]
> Sent: jeudi 1 mars 2001 13:44
> To: ADSM-L AT VM.MARIST DOT EDU
> 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 : neil_sharp AT ml DOT com