Heres one I use regularly

select volume_name, stgpool_name, pct_utilized, pct_reclaim, status, -
(date(last_write_date)) as DATE -
from volumes -
where volume_name in (select volume_name from libvolumes) -
order by 2,4


Allan Mills | AIX and TSM Administrator
Business & Technology Services | New South Wales Police

8835 9286 (internal 29286)



Paul Dudley <pdudley AT ANL.COM DOT AU>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
14/06/2006 17:24
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
[ADSM-L] 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.

All mail is subject to content scanning for possible violation of New
South Wales Police
electronic Mail Policy. All persons are required to familiarise themselves
with the
content of the policy located on the NSWP Intranet BULLETIN BOARD.




This message and any attachment is confidential and may
be privileged or otherwise protected from disclosure. If you
have received it by mistake, please let us know by reply
and then delete it from your system; you should not copy
the message or disclose its contents to anyone.