Re: List of tapes in vault

2002-03-22 Thread robert
: 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

Re: List of tapes in vault

2002-02-14 Thread Rick Saylor
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 Colle

Re: List of tapes in vault

2002-02-14 Thread Gabriel Wiley
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 Admi

Re: List of tapes in vault

2002-02-14 Thread David Longo
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

Re: List of tapes in vault

2002-02-14 Thread Prather, Wanda
Yes, but check your spellingVAULTRETRIEVE, 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... -