This is the script I use ..........

/*  --------------------------------------------*/
/*  Script Name:  Q_VOL_RECLM        */
/*  Description: Display the number of  */
/*               onsite tapes                      */
/*               eligible for                        */
/*               reclamation when the        */
/*               threshold is set to a           */
/*               specified value                  */
/*  Parameter 1: reclamation threshold  */
/*  Example:  run q_vol_reclm 60          */
/*  --------------------------------------------*/
select volume_name, pct_utilized, status, -
  stgpool_name, last_write_date from volumes -
  where upper(access)^='OFFSITE' -
  and pct_reclaim >= $1




At 07:03 AM 10/9/02 -0500, you wrote:

Hello all,

Does anyone have a script/SQL command to figure out how many tapes are below
the reclamation threshold?  I'm sure there has to be something easy, but
every command I've tried hasn't worked.

Thanks,

Rob Hefty
IS Operations
Lab Safety Supply