select volume_name,stgpool_name,pct_utilized from volumes where volume_name
like '3%' order by pct_utilized

Replace the 3% with whatever you tape volumes start with.

Hope this is what you are looking for.


Michael Moore
VF Services Inc.
105 Corporate Center Blvd.
Greensboro,  NC  27408
336.424.4423 (Voice)
336.424.4544 (Fax)
336.507.5199 (Pager)



                      Ken Sedlacek
                      <Ken_Sedlacek@KYR        To:       ADSM-L AT VM.MARIST 
DOT EDU
                      US.COM>                  cc:
                      Sent by: "ADSM:          Subject:  How to List library 
tape volumes by Pct Util?
                      Dist Stor
                      Manager"
                      <[email protected]
                      .EDU>


                      05/30/03 09:31 AM
                      Please respond to
                      "ADSM: Dist Stor
                      Manager"






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