select count(*) from volumes where stgpool_name='TAPEPOOL' and
pct_utilized<45 and status='FULL'

Replace TAPEPOOL with any tapepool names. 

Kenny Barnes
Systems Analyst
GmacInsurance
336-770-8280
kenny.barnes AT gmacinsurnace DOT com


-----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 12:03 PM
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?
--------------------------------------------------------------------------------------------------------------------------------------------------
Note:  The information contained in this message may be privileged and 
confidential
and protected from disclosure.  If the reader of this message is not the 
intended recipient,
or an employee or agent responsible for delivering this message to the intended 
recipient,
you are hereby notified that any dissemination, distribution or copying of this 
communication
is strictly prohibited.  If you have received this communication in error, 
please notify us 
immediately by replying to the message and deleting it from your computer.  
Thank you.
--------------------------------------------------------------------------------------------------------------------------------------------------