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: arnaud.brion AT panalpina DOT com
******************************************************************************

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
Paul Dudley
Sent: Wednesday, 14 June, 2006 09:25
To: ADSM-L AT VM.MARIST DOT EDU
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
pdudley AT anl.com DOT au





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.