Actually, the field DRIVES table, ALLOCATED_TO has the information.

Select drive_name, device_type from drives where allocated_to IS NULL

This works on V4.2.  This area dramatically changed on V5.  I do not have a
V5 system to look at what is required to get the same answer.

Paul D. Seay, Jr.
Technical Specialist
Naptheon Inc.
757-688-8180


-----Original Message-----
From: Christian Sandfeld [mailto:csa AT FERROSAN DOT COM]
Sent: Thursday, December 19, 2002 7:34 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SELECT statement to determine if any drives available


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