BackupExec is Veritas's small business backup solution and depending on the version, allows Volume information to be extracted via:

1. Command line,
2. Windows Power Shell, or
3. ODBC.

When Volumes are new, they will appear in the Scratch Media Set, but as they are used they are assigned to a specific Media Set. Unlike Veritas's NetBackup product, when Volumes expire, by default, they are not moved back into the Scratch Media Set.

bemcmd -o402 -r25 -ft:4 -f:"BE.csv" > "BE-CMD.txt" 2>&1

cd "C:\Program Files\Symantec\Backup Exec\Modules\BEMCLI" 
import-module BEMCLI

cd "C:\Program Files\TapeTrack\TapeTrack Sync\var"

#
# Get Media list from Backup Exec 
# 
$MediaList = Get-BEMedia 
$Today = Get-Date

# 
# Initialize the outout array 
# 
$Records = @()

ForEach ($Media in $MediaList) {
    $Record = "" | Select-Object CartridgeLabel, MediaSetName, MediaVault, RetentionHoursRemaining    
    $Record.CartridgeLabel = $Media.Name
    $Record.MediaSetName = $Media.MediaSet    
    $Record.MediaVault = $Media.MediaVault    
    $Record.RetentionHoursRemaining = [Int]($Media.OverwriteProtectedUntilDate - $Today).TotalHours    
    $Records += $Record 
}


$Records | Export-CSV -notype BE.csv

Synchronization with TapeTrack is performed by calling the TMSS10Sync command line program, along with:

1. The CSV output file.
2. Command line arguments that instructs the program how to process volumes.
3. A synchronization definition file that instructs the program how to interpret the CSV output.

Call Windows Powershell and run the BE-List script.
Call the TapeTrack Sync module and process the output created by the Powershell script.

powershell.exe -NoProfile -file "BE-List.ps1" -executionpolicy RemoteSigned 
TMSS10Sync -S user:-password@server -a -d BE.ttidef < BE.csv

Where:

• -d is the path to the Synchronization Definition File.
• -a tells the program to add new tape volumes if they are encountered.
• -S tells the program what Server to connect to.
• BE.CSV is the output from the BE-List script.

BE.ttidef

#
# Set the Customer and Media as literal values as they never change
#
SetLiteral(CUSTOMER, "ACME"); 
SetLiteral(MEDIA, "LTO"); 

#
# Set CSV delimiter
#
SetCSVDelimiter(",");
 
#
# Get the Volume-ID 
#
Extract(VOLUME, 1, 10, 0);
 
#
# Get the Repository from a translated location Name
# 
Extract(REPOSITORY, 0, 200, 0); 
AddTranslation(REPOSITORY, "*,WEEKLY_BACKUP,*,[0-9]*", "OFFS"); 
AddTranslation(REPOSITORY, "*", "LIBR");

#
# Set the Description to the Pool Name
#
Extract(DESCRIPTION, 2, 100, 0);
RemoveSpaces(DESCRIPTION);
#