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
