Thanks to all who responded:

Michael Moore
David E Ehresman
Richard Sims
Jeff White (off-line)

all of you suggestions are more than adequate.

Thank you!


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





Michael Moore <Michael_Moore AT VFC DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
05/30/03 10:36 AM
Please respond to "ADSM: Dist Stor Manager"

        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: How to List library tape volumes by Pct Util?


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