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:[EMAIL PROTECTED] Enviada em: Tuesday, August 31, 2004 1:03 PM Para: [EMAIL PROTECTED] 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?
