SELECT * FROM VOLUMES WHERE STATUS='PENDING'

Look at the PENDING_DATE field.

-----Original Message-----
From: Mire, Nona [mailto:MireN AT LOURDESRMC DOT COM]
Sent: Wednesday, May 21, 2003 1:06 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: pending tapes to scratch


Is there a way to tell how many days a tape has been in the pending state.
I have our system setup for 7 days - but am running low on scratch tapes.  I
have lots of pending and just wanted an idea as to which ones are going to
be back in the next couple of days to know whether I need to start
worrying....

Thanks
Nona Mire