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:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:39 AM To: [EMAIL PROTECTED] Subject: Re: SELECT statement to determine if any drives available select drive_name,drive_state,allocated_to,online from drives >>> [EMAIL PROTECTED] 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