The select is:

select volume_name,pending_date,status from volumes where
stgpool_name='BLAH' and status='PENDING'

Use for each tape storage pool you have.  Note: Use uppercase for stgpool Name.


David B. Longo
System Administrator
Health First, Inc.
3300 Fiske Blvd.
Rockledge, FL 32955-4305
PH      321.434.5536
Pager  321.634.8230
Fax:    321.434.5509
david.longo AT health-first DOT org


>>> MireN AT LOURDESRMC DOT COM 05/21/03 02:06PM >>>
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

##############################################################
This message is for the named person's use only.  It may 
contain confidential, proprietary, or legally privileged 
information.  No confidentiality or privilege is waived or 
lost by any mistransmission.  If you receive this message 
in error, please immediately delete it and all copies of it 
from your system, destroy any hard copies of it, and notify 
the sender.  You must not, directly or indirectly, use, 
disclose, distribute, print, or copy any part of this message
if you are not the intended recipient.  Health First reserves
the right to monitor all e-mail communications through its
networks.  Any views or opinions expressed in this message
are solely those of the individual sender, except (1) where
the message states such views or opinions are on behalf of 
a particular entity;  and (2) the sender is authorized by 
the entity to give such views or opinions.
##############################################################