Hi All,

I'm running TSM 4.2.1.7.  And I'd like to a select statement for all volumes
in the library which are in a storage pool and are not mounted.  I've got
most of the select statement figured out.

select volume_name from volumes where stgpool_name = 'RMANDEV' and
volume_name in ( select volume_name from libvolumes )

How can I remove mounted volumes from the select?

Any help would be greatly appreciated

Ray Baughman
Engineering Systems Administrator
TSM Administrator
National Machinery Co.
Phone:   419-443-2257
Fax:     419-443-2376
Email:   rbaughman AT nationalmachinery DOT com