Audit Procedure of missing tapes TSM Vs Offsite

[LarryB]

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?)

 

[AjithS]

Hi-

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

Finding 'lost' tapes:
http://tsmblog.asmholdings.info/2009/04/finding-lost-tape-volumes.html

A Library Audit Procedure:
http://tsmblog.asmholdings.info/2009/04/running-tsm-library-audit.html

I trust this will help.

 

[picay]

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

 

[Castaway]

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