How about  this for TSM:

select VOLUME_NAME,ACCESS from volumes where access ='READONLY', STATUS
from media where VOLUME_NAME='FILLING'

Keith M Williams/Dubuque/IBM
Unix System Administrator, IBM Dubuque
ITDelivery, Global Technology Services
kwilliam AT us.ibm DOT com




From:
Timothy Hughes <Timothy.Hughes AT OIT.STATE.NJ DOT US>
To:
ADSM-L AT vm.marist DOT edu
Date:
11/15/2010 07:40 AM
Subject:
select statement to display readonly and filling tapes
Sent by:
"ADSM: Dist Stor Manager" <ADSM-L AT vm.marist DOT edu>



Hi

I am trying to add "filling" tapes to this select statement and I am
having no luck does anyone have a select statement that shows this?



I already have most of the statement below i just need to add "filling"
to the statement

select VOLUME_NAME,ACCESS from volumes where access ='READONLY'


thanks for any help