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:

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.

Further details on the conversion process can be viewed at Data Protector Cookbook

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

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.

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.

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