Mine is blank also.  I suspect that is used for if a drive is DEDICATED
to
a certain process, session or whatever.

David Longo

>>> Wanda.Prather AT JHUAPL DOT EDU 12/19/02 11:52AM >>>
That's interesting - what shows up in your "allocated-to" field?  (Mine
has
nothing, even when tapes are mounted to processes and restores..)

-----Original Message-----
From: David E Ehresman [mailto:deehre01 AT LOUISVILLE DOT EDU]
Sent: Thursday, December 19, 2002 9:39 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: SELECT statement to determine if any drives available


 select drive_name,drive_state,allocated_to,online from
  drives

>>> csa AT FERROSAN DOT COM 12/19/02 07:34AM >>>
Hi list,

Does anybody know of a SELECT statement that will show if any drives
are
available for use (not in use by another process or session)?

I need this for scripting purposes as I have only two drives in my
library,
and while doing reclamation both drives are in use.


Kind regards,

Christian


"MMS <health-first.org>" made the following
 annotations on 12/19/2002 01:18:02 PM
------------------------------------------------------------------------------
This message is for the named person's use only.  It may contain confidential, 
proprietary, or legally privileged information.  No confidentiality or 
privilege is waived or lost by any mistransmission.  If you receive this 
message in error, please immediately delete it and all copies of it from your 
system, destroy any hard copies of it, and notify the sender.  You must not, 
directly or indirectly, use, disclose, distribute, print, or copy any part of 
this message if you are not the intended recipient.  Health First reserves the 
right to monitor all e-mail communications through its networks.  Any views or 
opinions expressed in this message are solely those of the individual sender, 
except (1) where the message states such views or opinions are on behalf of a 
particular entity;  and (2) the sender is authorized by the entity to give such 
views or opinions.

==============================================================================