This is an old revision of the document!
Table of Contents
Data Extraction From Source
Data is extracted from your backup software and saved into a Sync source file. The Sync source file is then read into the synchronization process using a definition file to translate the information to TapeTrack formatting.
Extracting Information
The source file information extract will vary depending on your backup software.
Data Extraction From Networker
Using the administrative tool mminfo, the Volume data needs to be extracted from the Networker save sets and exported into CSV file format.
To get a report that is suitable for the TapeTrack Sync command, the following minimum arguments should be used:
mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
Data Extraction From TSM
Using the Tivoli Storage Manager administrative tool dsmadmc, the Volume data needs to be extracted from both the DRM and Volume tables and exported into csv file format.
To get a report that is suitable for the TapeTrack Sync command, the following minimum arguments should be used:
From the DRM table:
From the DRM table, select the fields:
- volume_name: Used to determine the Volume-ID in TapeTrack.
- state: Used to determine the location the Volume should be.
- stgpool_name: Used to set the Volume Description.
dsmadmc -dataonly=yes -id=userid -pa=password -tcpserveraddress=tsm01.gazillabyte.local \
-displaymode=table -outfile=TSM-DRM.csv -commadelimited "select volume_name,state,stgpool_name from drmedia"
From the Volume table:
From the Volume table, select the fields:
- volume_name: Used to determine the Volume-ID in TapeTrack
- location: Used to determine the location the Volume is.
- stgpool_name: Used to set the Volume Description.
dsmadmc -dataonly=yes -id=userid -pa=password -tcpserveraddress=tsm01.gazillabyte.local \
-displaymode=table -outfile=TSM-VOL.csv -commadelimited "select volume_name,location,stgpool_name from volumes"
Data Extraction For VEEAM
VEEAM differs from other backup software in that a direct ODBC connection is made using the definition file rather than extracting the data to file and then using a definition file to read it.
Sample code placed at the beginning of the definition to connect to sample database veeam2.
# Connect to Veeam database
SetODBC("DSN=veeam2");
# Extract data
SetSQL("SELECT [barcode],[media_pool_id],[last_write_time] FROM [VeeamBackup].[dbo].[Tape.tape_mediums]");