Results 1 to 4 of 4
  1. #1
    Member
    Join Date
    Apr 2008
    Location
    Auckland, New Zealand
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Audit Procedure of missing tapes TSM Vs Offsite

    Hi all,


    I am looking at writing a script to audit or reconcile tapes offsite at the vault with what the TSM server knows about. Everything would be based at a specific time, e.g. 10pm

    If I collect tape information for the TSM server such as
    q drmedia
    q volhist
    q vol
    tapes in transit (to/from)

    and compare this with a list of tapes held by offsite company. Is this good enough to locate the “orphans” (tapes lost from the TSM server)?

    Or better are there any scripts or links that document this?

    Question: Is q drmedia a sublist of q vol ? (does q vol have the same tapes as produced by dr media?)

  2. #2
    Member
    Join Date
    Mar 2009
    Location
    Pretoria, South Africa
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Audit Procedure of missing tapes TSM Vs Offsite

    Hi-

    You can refer to my blog http://tsmblog.asmholdings.info

    Finding 'lost' tapes:
    http://tsmblog.asmholdings.info/2009...e-volumes.html

    A Library Audit Procedure:
    http://tsmblog.asmholdings.info/2009...ary-audit.html

    I trust this will help.

  3. #3
    Member
    Join Date
    Oct 2004
    Posts
    212
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default

    select distinct volume_name from volhistory where devclass='YOURDEVCLASS' and volume_name not in (select volume_name from libvolumes where library_name='YOURLIBRARY') and volume_name not in (select volume_name from drmedia) and volume_name not in (select volume_name from volumes where devclass_name='YOURDEVCLASS') order by volume_name

  4. #4
    Member Castaway's Avatar
    Join Date
    Sep 2005
    Location
    Boonedocks
    Posts
    37
    Thanks
    1
    Thanked 1 Time in 1 Post

    Default

    PICAY, this script worked very well for my 3494 library - thanks!
    Living the dash

Similar Threads

  1. TSM Offsite Procedure
    By Keyrun in forum Restore / Recovery Discussion
    Replies: 6
    Last Post: 01-23-2013, 11:37 AM
  2. Replies: 11
    Last Post: 05-14-2008, 10:36 AM
  3. Tapes missing in TSM after vaultr
    By jbryan605 in forum Backup / Archive Discussion
    Replies: 9
    Last Post: 02-26-2008, 09:47 PM
  4. Replies: 2
    Last Post: 10-30-2007, 06:10 PM
  5. Proper procedure to take out offsite tapes
    By Elomis in forum Backup / Archive Discussion
    Replies: 1
    Last Post: 10-29-2007, 11:41 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •