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:[EMAIL PROTECTED] On Behalf Of James Lepre Sent: Tuesday, August 31, 2004 12:03 PM 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? -------------------------------------------------------- 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/ --------------------------------------------------------
