Just Change the Stgpool name and % for what you need...
                                                                                
                
select count(*) from volumes where pct_reclaim>95 and 
stgpool_name='TAPE_ARCHIVE_COPY'

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU]On Behalf Of
James Lepre
Sent: Tuesday, August 31, 2004 11:03 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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?