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: [EMAIL PROTECTED]