select volume_name,pct_utilized from volumes where access<>'OFFSITE'
order by pct_utilized desc

>>> Ken_Sedlacek AT KYRUS DOT COM 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
ksedlacek AT kyrus DOT com

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