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:[EMAIL PROTECTED] Behalf Of James Lepre Sent: Tuesday, August 31, 2004 11:03 AM To: [EMAIL PROTECTED] 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?
