NetBackup is Veritas's enterprise backup solution and is available for Windows, UNIX and Linux.

NetBackup Vault is a component of NetBackup that is used to set the Vault Location field in NetBackup. It may or may not be deployed.

In the event that it is deployed TapeTrack Sync can use the Vault Location field set in NetBackup to determine the expected location of each tape volume. If Vault is not deployed, TapeTrack can determine the expected location based upon other fields such as the tape expiration date.

The vmquery man page describes the command as:

Query the Enterprise Media Manager database, or assign and unassign volumes

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

vmquery -W -a > Inventory.txt

Where:

• -W sets the report to wide format with space delimiters.
• -a tells the command to list all volumes.

Other arguments that might be required are:

• -h which sets the EMM server and must be used to run the command against a remote host.

As previously noted, the -W argument produces space delimited output, but adds a space between date/time values which will be confused with space delimiters.

To fix the date/time values and convert the output into a more readable CSV format, the TMSS10SingleSpace should be used as follows:

vmquery -W -a > Inventory.txt
TMSS10SingleSpace -d "," -g "??/??/???? ??:??" < Inventory.txt > Inventory.csv

It is common for NetBackup barcodes to be missing the LTO L-Suffix, and also common for the Media Type field to have a HCART value that does not truly reflect the correct LTO generation.

If is always recommended that where possible volumes be loaded into TapeTrack with their L-Suffix, and this suffix can be established by:

1. The Media ID value if it includes the suffix.
2. Adding an appropriate suffix to the Media ID based upon the value of the Media Type field.
3. Adding an appropriate suffix based upon the range of the Media ID.
4. Using TapeTrack's Constructive Barcode feature.

#
# Set the Customer and Media as literal values as they never change
#
SetLiteral(CUSTOMER, "ACME");
SetLiteral(MEDIA, "LTO");
#
# Set the delimiter to a CSV
#
SetCSVDelimiter(",")
#
# Set the Description to the Pool Name
#
Extract(DESCRIPTION, 4, 40, 0);
#
# Get the Volume-ID from the report and add L5 to the E* tapes and L4 to the P* tapes
#
Extract(VOLUME, 1, 6, 0);
AddTranslation(VOLUME, "E*", "*L5");
AddTranslation(VOLUME, "P*", "*L3");
#
# Get the Repository from a translated Pool Name
#
Extract(REPOSITORY, 4, 40, 0);
#
AddTranslation(REPOSITORY, "NDMP_Full", "OFFS");
AddTranslation(REPOSITORY, "Infrastructure", "OFFS");
AddTranslation(REPOSITORY, "Oracle_Servers", "OFFS");
AddTranslation(REPOSITORY, "VMWare", "OFFS");
AddTranslation(REPOSITORY, "PQP-[1-4]", "OFFS");
AddTranslation(REPOSITORY, "Exchange", "OFFS");
AddTranslation(REPOSITORY, "Oracle_Full", "OFFS");
AddTranslation(REPOSITORY, "UserDept-Full", "OFFS");
AddTranslation(REPOSITORY, "NDMP_Indefinite", "OFFS");
AddTranslation(REPOSITORY, "Infrastructure_Indef", "OFFS");
AddTranslation(REPOSITORY, "EDW-DWG_Indef", "OFFS");
AddTranslation(REPOSITORY, "PQP-[1-4]-Indef", "OFFS");
AddTranslation(REPOSITORY, "PTNAP_Full", "OFFS");
AddTranslation(REPOSITORY, "EDW_3Year", "OFFS");
#
# Everything else should go to LIBR, but if it was at OFFS it will skip
#
AddTranslation(REPOSITORY, "*", "LIBR");