you can try :

dsmadmc -id=YOURNAME -pass=YOURPASS -outfile \
"select distinct(volume_name) \
from volumeusage \
where node_name='YOURNODE'"

hth


A 12:43 01/03/2001 -0000, vous avez écrit :
>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
>
>
                        - * - * - * - * - * - * -
Mes idees n'engagent que moi (vieux proverbe du Net)

Thierry ITTY
eMail : Thierry.Itty AT Besancon DOT org               FRANCE