Re: List of tapes in vault
2002-02-14 12:55:02
David
Try asking for what is not in your library. The select below will list
every tape not in the library. So, this would also include tapes being
transported to/from the vault.
select volume_name as "Tape Number", location from drmedia where lib_name
is null
Rick Saylor
Austin Community College
At 11:12 AM 2/14/02 -0500, you wrote:
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.
--------------------------------------------------------------------------
Rick Saylor Austin Community College Voice: (512)223-1182
Rick Saylor Austin Community College Voice: (512)223-1182
Senior Systems Programmer 9101 Tuscany Way Fax: (512)223-1211
Information Services Austin, Texas 78754
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- List of tapes in vault, Tyree, David
- Re: List of tapes in vault,
Rick Saylor <=
- Re: List of tapes in vault, Prather, Wanda
- Re: List of tapes in vault, Davidson, Becky
- Re: List of tapes in vault, David Longo
- Re: List of tapes in vault, Gabriel Wiley
- List of tapes in vault, Tyree , David [mailto:david.tyree
- List of tapes in vault, Tyree , David [mailto:david.tyree
|
|
|