Could try this one:

select v.volume_name,v.stgpool_name,v.pct_utilized,p.reclaim from
volumes as v,stgpools as p where v.stgpool_name=p.stgpool_name and
v.pct_utilized<100-p.reclaim

This one gets the reclaim% from the stgpool definition


Paul Gondim van Dongen
MCSE
IBM Certified Deployment Professional -- Tivoli Storage Manager V5.2
VANguard - Value Added Network guardians
http://www.vanguard-it.com.br
+55 81 3225-0353


-----Mensagem original-----
De: James Lepre [mailto:JLEPRE AT NECA DOT ORG] 
Enviada em: Tuesday, August 31, 2004 1:03 PM
Para: ADSM-L AT VM.MARIST DOT EDU
Assunto: Re: SQL Select


I am trying to find a statement that would allow me to see what tapes
need to be reclaimed.  Can this be done?