select volume_name,pct_utilized from volumes where access<>'OFFSITE' order by pct_utilized desc
>>> [EMAIL PROTECTED] 05/30/03 09:31AM >>> Enviro: AIX TSM server 4.2.2.12 (I know, I need to upgrade!) MagStar 3570 C12 library Can someone suggest a query to list all the volumes in the library sorted by "Pct Util"? ps-I wish there was some way to find these queries that exist in the adsm.org archives. Does anyone know of some good keywords to use for a search on such a query in the adsm archives?? TIA. Ken Sedlacek AIX/TSM/UNIX Administrator [EMAIL PROTECTED] IBM Certified Specialist: RS/6000 AIX v4.3 Support IBM Certified Specialist: RS/6000 SP & PSSP 3 Tivoli Certified Consultant - Tivoli Storage Manager v4.1
