1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Audit Procedure of missing tapes TSM Vs Offsite

Discussion in 'BCP / DRP' started by LarryB, Jul 20, 2009.

  1. LarryB

    LarryB ADSM.ORG Member

    Joined:
    Apr 17, 2008
    Messages:
    94
    Likes Received:
    1
    Location:
    Auckland, New Zealand
    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.  
  3. AjithS

    AjithS ADSM.ORG Member

    Joined:
    Mar 19, 2009
    Messages:
    6
    Likes Received:
    0
    Occupation:
    TSM Consultant
    Location:
    Pretoria, South Africa
  4. picay

    picay ADSM.ORG Member

    Joined:
    Oct 22, 2004
    Messages:
    212
    Likes Received:
    0
    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
     
  5. Castaway

    Castaway ADSM.ORG Member

    Joined:
    Sep 22, 2005
    Messages:
    37
    Likes Received:
    1
    Occupation:
    TSM Admin
    Location:
    Boonedocks
    PICAY, this script worked very well for my 3494 library - thanks!
     

Share This Page