Hi Paul, I believe that this SQL query should fit your request :
select volume_name,stgpool_name,devclass_name,est_capacity_mb,pct_utilized,status from volumes where volume_name in (select volume_name from libvolumes) Cheers. Arnaud ****************************************************************************** Panalpina Management Ltd., Basle, Switzerland, CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH Phone: +41 (61) 226 11 11, FAX: +41 (61) 226 17 01 Direct: +41 (61) 226 19 78 e-mail: [EMAIL PROTECTED] ****************************************************************************** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Paul Dudley Sent: Wednesday, 14 June, 2006 09:25 To: [email protected] Subject: q vol and q libvol Rather than going back and forth between the output of the "q vol" and "q libvol" commands is there a command that would give me the output from the "q vol" command but only for those tape volumes that show up in the "q libvol" command? Regards Paul Paul Dudley ANL IT Operations Dept. ANL Container Line [EMAIL PROTECTED] ANL DISCLAIMER This e-mail and any file attached is confidential, and intended solely to the named addressees. Any unauthorised dissemination or use is strictly prohibited. If you received this e-mail in error, please immediately notify the sender by return e-mail from your system. Please do not copy, use or make reference to it for any purpose, or disclose its contents to any person.
