Try this select statement. Change pct_utilized as per your environment
requirement.

select volume_name,stgpool_name,devclass_name from volumes where
status='FULL' and pct_utilized<51

Regards, Samiran Das


-----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? 
--------------------------------------------------------
 
If you are not an intended recipient of this e-mail, please notify the sender, 
delete it and do not read, act upon, print, disclose, copy, retain or 
redistribute it. Click here for important additional terms relating to this 
e-mail.     http://www.ml.com/email_terms/ 
--------------------------------------------------------