You don't need select for this simple one.  Use:

q drmedia * wheresate=vaultr

You can use same command with all other states to see where they are.

I have our vault send me an inventory about every 2 months and I 
compare.  You have to remember that their "snapshot"  of the
Vault and yours will need some adjusting.  It's sort of like doing
a reconciliation of your bank statement.  (Like what we have sent them 
that they hadn't vaulted yet when they ran their list, etc.)

David Longo


>>> david.tyree AT SGMC DOT ORG 02/14/02 11:12AM >>>
        Does anyone have a easy way to find out which tapes are supposed to
be in the vault? I need to check every so often to make sure the operator is
bringing back the tapes correctly. I'm not sure if the following is correct:

select volume_name as "Tape Number" from drmedia where state='VAULT' OR
STATE='VAULTRETRIVE' OR STATE='COURIERRETIRVE'

If I run this I get a list of tapes that I should find in the vault right?

David Tyree
Microcomputer Specialist
South Georgia Medical Center
229.333.1155

Confidential Notice:  This e-mail message, including any attachments, is for
the sole use of the intended recipient(s) and may contain confidential and
privileged information.  Any unauthorized review, use,  disclosure or
distribution is prohibited.  If you are not the intended recipient, please
contact the sender by reply e-mail and destroy all copies of the original
message.



"MMS <health-first.org>" made the following
 annotations on 02/14/02 11:59:45
------------------------------------------------------------------------------
---
This message is for the named person's use only.  It may contain 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.

==============================================================================