Re: List of tapes in vault
Hi, There is an easy way to administer your tapes even a monkey could do it http://www.tsmmediamanager.nl/index2.html Have a look. Robert -Original Message- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 12:06 PM To: [EMAIL PROTECTED] Subject: Re: List of tapes in vault David I am not sure that will include the database backups that you may or may not be sending offsite q drm wherest=vault source=dbsnapshot(or whatever your dbbackup is) will give you a list of all in vault status. You can add to that vaultretrieve or just leave the wherest off. Becky -Original Message- From: Tyree, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 10: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.
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.
Re: List of tapes in vault
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. ==
Re: List of tapes in vault
Tyree, type help q drm this will give you all the states that a DRM tape can have, once you know the difference btween them all you can specify what status you want to display.. I can tell you that Mountable are the tapes that need to go to vault... N-joy Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza Tyree, David david.tyree@SGMCTo: [EMAIL PROTECTED] .ORGcc: Sent by: ADSM: Subject: List of tapes in vault Dist Stor Manager [EMAIL PROTECTED] .EDU 02/14/2002 11:12 AM Please respond to ADSM: Dist Stor Manager 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.
Re: List of tapes in vault
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 SaylorAustin Community College Voice: (512)223-1182 Senior Systems Programmer 9101 Tuscany Way Fax: (512)223-1211 Information Services Austin, Texas 78754