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