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.

The source file information extract will vary depending on your backup software.

The onmirpt command is available on systems with the Data Protector User Interface component installed

Use the omnirpt command to extract data to a text file using:

omnirpt -report media_list -tab > var\dataprotector.csv

Output from omnirpt, while tab delimitered, can produce offset columns depending on string lengths. To ensure the column offsets are consistent the output is passed through TMSS10CSV2Fixed producing a fixed length text file.

TMSSDELIMETER=TAB
 
TMSS10CSV2Fixed < dataprotector.csv

Using the administrative tool vmquery, the Volume data can be extracted into a text file.

To get a report that is suitable for the TapeTrack Sync command, the following minimum arguments should be used:

vmquery -W -a > Report.txt

The text file is then converted to a CSV file to properly format the data, along with the dates, to allow correct loading into the Sync, using the command line program TMSS10SingleSpace.

TMSS10SingleSpace -d "," -g "??/??/???? ??:??" < Report.txt > Report.csv

Full definition and implementation example for extraction of data and synchronization with Netbackup is at NetBackup Sync Cookbook

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

Full definition and implementation example for extraction of data and synchronization with Networker is at NetWorker Sync Cookbook

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, 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, 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"

Full definition and implementation example for extraction of data and synchronization with TSM is at Tivoli Storage Manager Sync Cookbook

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]");