Differences

This shows you the differences between two versions of the page.

--- cookbook:networker [2018/09/19 02:50] – [Extracting Networker Information] Scott Cunliffe
+++ cookbook:networker [2025/01/23 03:50] (current) – [Example Synchronization Definition] Gerard Nicol
@@ Line 1: / Line 1: @@
-====== Networker Sync Cookbook======
+====== NetWorker Sync Cookbook======
-[[https://en.wikipedia.org/wiki/EMC_NetWorker|Networker]] is a Dell EMC backup solution and is available for Linux, Windows, macOS, NetWare, OpenVMS and Unix.
+[[https://en.wikipedia.org/wiki/EMC_NetWorker|NetWorker]] is a Dell EMC backup solution and is available for Linux, Windows, macOS, NetWare, OpenVMS and Unix.
+===== Data Extraction From Networker =====
+The first step in Synchronizing your Networker Library with TapeTrack is to extract the Volume data from your Networker instance.
+Using the administrative tool mminfo, the Volume data needs to be extracted from the Networker save sets and exported into CSV file format.
+{{mminfo_extract.png}}
 ===== The mminfo command =====
-The mminfo main page describes the command as:
+The mminfo command reports information about NetWorker media and save sets.
-> Reports information about NetWorker media and save sets
+To get a report that is suitable for the TapeTrack Sync command, the following minimum arguments should be used:
-First step in syncing volume information from Networker is to extract a text or csv file with the volume, barcode, family, type, location and pool by running the mminfo command.
+<code plain;>
-<sxh plain;>
 mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
-</sxh>
+</code>
-Sample output
+==== Example mminfo output ====
-<sxh plain;>
+=== Output With Suffix ===
+<code plain;>
 volume,barcode,family,type,location,pool
 L6,000000L6,tape,LTO,Offsite,weekly_full
@@ Line 27: / Line 34: @@
 L6,000006L6,tape,LTO,Offsite,weekly_full
 L6,000007L6,tape,LTO,Offsite,weekly_full
-</sxh>
+</code>
+=== Output Without Suffix ===
-To interpret the output in the file we use a definition file (default.ttidef) which reads the data in the Networker file, line by line, and parses the information which TMSS10Sync then uses to update the volumes location (and other data as specified) in the TapeTrack Server.  It is best practice to write the definition file in a program like Notepad or Vi to ensure it is plain text and has no hidden control characters.
+<code plain;>
+volume,barcode,family,type,location,pool
+,000000,tape,LTO,Offsite,weekly_full
+,000001,tape,LTO,Offsite,weekly_full
+,000002,tape,LTO,Offsite,weekly_full
+,000003,tape,LTO,Offsite,weekly_full
+,000004,tape,LTO,Offsite,weekly_full
+,000005,tape,LTO,Offsite,weekly_full
+,000006,tape,LTO,Offsite,weekly_full
+,000007,tape,LTO,Offsite,weekly_full
+</code>
+==== Post-processing ====
-===== default.ttidef =====
+<note important>You will need to install the [[cli:sync_suite|TapeTrack Sync software]] to complete these instructions.</note>
-default.ttidef file sample with code to:
+==== Barcodes ====
-  * Set CSV file delimiter (2)
+It possible for NetWorker barcodes to be missing the LTO L-Suffix.
-  * Exclude any string that starts with barcode (5)
-  * Set customer ID to US01 (8)
-  * Set media ID to LTO (9)
-  * Set default repository to LIBR (12)
-  * extract volume ID from column 1, length 8 characters (15)
-  * extract volume description from column 6, length 50 characters (18)
-  * If description contains the string "Offsite" set repository to **OFFS** (21)
-<sxh plain;>
+It is always recommended that where possible volumes are loaded into TapeTrack with their L-Suffix, and this suffix can be established by:
-# Set CSV delimiter
+  - The Media-ID value if it includes the suffix.
-SetCSVDelimiter(",");
+  - Adding an appropriate suffix to the Media-ID based upon the value of the Media Type field.
+  - Adding an appropriate suffix based upon the range of the Media-ID.
+  - Using TapeTrack's Constructive Barcode feature.
-# Skip any line that begins with barcode (header)
+===== Synchronization =====
-AddString(EXCLUSION, 0, "barcode*");
-# Set customer ID and media ID to sync with
+Synchronization with TapeTrack is performed by calling the [[cli:TMSS10Sync|TMSS10Sync]] command-line program, along with:
-setLiteral(CUSTOMER, "US01");
-setLiteral(MEDIA, "LTO");
-# All volumes initially set to library
+  - The CSV file produced by pre-processing the mminfo output.
-setLiteral(REPOSITORY, "LIBR");
+  - Command-line arguments that instruct the program how to process volumes.
+  - A synchronization definition file that instructs the program how to interpret the mminfo output.
-# Extract Volume ID from column 1 (up to eight characters long)
+{{networker_sync.png}}
-Extract(VOLUME, 1, 8, 0);
-# Extract volume Description from column 6 (up to fifty characters long)
+==== Example Command Line Arguments ====
-Extract(DESCRIPTION, 6, 50, 0);
-# Send any volume from the pool **offsite** to OFFS repository
+<code>
-AddTranslation2(REPOSITORY, DESCRIPTION, "Offsite*", "OFFS");
+TMSS10Sync -d Volume.ttidef -a -S user:-password@server < report.csv
-</sxh>
+</code>
+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 [[cli:server_argument|Server]] to connect to.
+  * ''report.csv'' is the ''mminfo'' output file.
-===== Sync Information =====
-Create a batch file with code to run Networkers mminfo command and then TMSS10Sync with the required parameters to input the report.csv file and default.ttidef file.  Running with the -M command will place the Sync in dump mode, which allows you to check the output from the process without executing any alterations in the TapeTrack Server.
+==== Example Synchronization Definition ====
-Sample batch file to run mminfo, pass the information to TMSS10Sync and output a dump of information.
+<code plain;>
-<sxh plain;>
+#
-mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
+# Set the Customer and Media as literal values as they never change
+#
-TMSS10Sync -M < report.csv > stdout.txt 2> stderr.txt
+SetLiteral(CUSTOMER, "ACME");
-</sxh>
+SetLiteral(MEDIA, "LTO");
+#
-When you are happy with the output, remove the -M attribute and insert -S attribute and access credentials for the TMSS10Sync command line.  Adding an attribute -a will add any new volumes in Networker not present in TapeTrack.
+# Set the delimiter to a CSV
+#
-<sxh plain;>
+SetCSVDelimiter(",");
-mminfo -xc, -a -r "volume,barcode,family,type,location,pool" > report.csv
+#
+# Skip any line that begins with string volume (header)
+AddString(EXCLUSION, 0, "volume*");
+#
+# Set the Description to the Pool Name
+#
+Extract(DESCRIPTION, 6, 20, 0);
+RemoveSpaces(DESCRIPTION);
+#
+# Get the Volume-ID from the report
+Extract(VOLUME, 1, 8, 0);
+#
+# Get the Repository from a translated location
+Extract(REPOSITORY, 5, 20, 0);
+RemoveSpaces(REPOSITORY);
+#
+# Send any volume from the pool **offsite** to OFFS repository, all others to LIBR
+AddTranslation(REPOSITORY, "Offsite*", "OFFS");
+AddTranslation(REPOSITORY, *, "LIBR");
-TMSS10Sync -S user:-password@server -a < report.csv > stdout.txt 2> stderr.txt
+</code>
-</sxh>
-===== Automating The Sync Process =====
-Once the Sync process is set up and running correctly, the batch file can be run automatically every hour (or at a time frame that suits) through windows scheduler to keep TapeTrack up to date.
+<- :cookbook:netbackup|NetBackup Sync Cookbook ^ :cookbook:introduction|Cookbook ^ :cookbook:tsm|Tivoli Storage Management Sync Cookbook->
+{{tag> cookbook}}