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
>>> [EMAIL PROTECTED] 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 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.
==============================================================================
