Yes, but check your spelling....VAULTRETRIEVE, COURIERRETRIEVE ALso, it depends on who is issuing the MOVE DRMEDIA commands and when, as to whether your COURIERRETRIEVE state tapes are still at the vault, or have already left your vault and are on the way back; but you've got the right idea...
-----Original Message----- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: List of tapes in vault 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.