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 Senior Systems Programmer 9101 Tuscany Way Fax: (512)223-1211 Information Services Austin, Texas 78754