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.

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