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.

<sxh> bemcmd -o402 -r25 -ft:4 -f:“BE.csv” > “BE-CMD.txt” 2>&1 </sxh>

<sxh> 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 </sxh>

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.

<sxh> powershell.exe -NoProfile -file “BE-List.ps1” -executionpolicy RemoteSigned TMSS10Sync -S user:-password@server -a -d BE.ttidef < BE.csv </sxh>

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

<sxh> # # 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); # </sxh>