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:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 7:34 AM To: [EMAIL PROTECTED] 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