Differences

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

--- cookbook:netbackup [2020/02/19 04:03] – [Data Extraction From Netbackup Vault] Scott Cunliffe
+++ cookbook:netbackup [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 15: / Line 15: @@
 ===== Data Extraction From Netbackup Vault =====
-The first step in Syncronizing your Netbackup Vault Library with TapeTrack is to extract the Volume data from your Netbackup Vault instance.
+The first step in Synchronizing your Netbackup Vault Library with TapeTrack is to extract the Volume data from your Netbackup Vault instance.
 Using the administrative tool vmquery, the Volume data can be extracted into a text file.
+{{vmquery_extract.png}}
 ===== The vmquery command =====
+<note important>NetBackup's vmquery must be installed and in current path to access the Volume information.\\
+\\
+If vmquery is not installed please refer to your NetBackup administrator.</note>
 The vmquery main page describes the command as:
-> Query the Enterprise Media Manager database, or assign and unassign volumes
+> Query the Enterprise Media Manager database, or assign and un-assign volumes
 To get a report that is suitable for the TapeTrack Sync command, the following minimum arguments should be used:
-<sxh plain;>
+<code plain;>
-vmquery -W -a > Inventory.txt
+vmquery -W -a > Report.txt
-</sxh>
+</code>
 Where:
   * ''-W'' sets the report to wide format with space delimiters.
@@ Line 39: / Line 45: @@
 ==== Example vmquery output ====
-<sxh plain;>
+<code plain;>
 MediaID OpticalPartner MediaType Barcode BarcodePartner RobotHost RobotType RobotNum RobotSlot Side/Face VolumeGroup Pool PoolNum PrevPool NumOfMounts MaxMounts NumOfCleanings CreateDatetime AssignedDatetime FirstMountDatetime LastMountDatetime ExpirationDatetime Status OffsiteLocation OffsiteSentDatetime OffsiteReturnDatetime OffsiteSlotID OffsiteSessionID Version DescriptionLength Description ContainerID
 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ Line 52: / Line 58: @@
 E00008 - HCART    E00008 - bak901.corp.store.net TLD 1 8 - 000_00001_TLD NDMP_Incremental 9 - 6 0 - 11/02/2012 19:03 01/04/2013 05:00 12/10/2012 08:16 01/07/2013 05:01 00/00/0000 00:00 0 - 00/00/0000 00:00 00/00/0000 00:00 - - 50 22 Added by Media Manager -
 E00009 - HCART    E00009 - bak901.corp.store.net TLD 1 16 - 000_00001_TLD NDMP_Incremental 9 - 6 0 - 11/02/2012 19:03 01/07/2013 05:00 12/10/2012 08:24 01/08/2013 05:02 00/00/0000 00:00 0 - 00/00/0000 00:00 00/00/0000 00:00 - - 50 22 Added by Media Manager -
-</sxh>
+</code>
 ==== Post-processing ====
@@ Line 63: / Line 69: @@
-<sxh plain;>
+<code plain;>
-vmquery -W -a > Inventory.txt
+vmquery -W -a > Report.txt
-TMSS10SingleSpace -d "," -g "??/??/???? ??:??" < Inventory.txt > Inventory.csv
+TMSS10SingleSpace -d "," -g "??/??/???? ??:??" < Report.txt > Report.csv
-</sxh>
+</code>
+{{vmquery_extract_csv.png}}
 === Example TMSS10SingleSpace output===
-<sxh plain;>
+<code plain;>
 MediaID,OpticalPartner,MediaType,Barcode,BarcodePartner,RobotHost,RobotType,RobotNum,RobotSlot,Side/Face,VolumeGroup,Pool,PoolNum,PrevPool,NumOfMounts,MaxMounts,NumOfCleanings,CreateDatetime,AssignedDatetime,FirstMountDatetime,LastMountDatetime,ExpirationDatetime,Status,OffsiteLocation,OffsiteSentDatetime,OffsiteReturnDatetime,OffsiteSlotID,OffsiteSessionID,Version,DescriptionLength,Description,ContainerID
 -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
@@ Line 83: / Line 91: @@
 E00008,-,HCART,E00008,-,bak901.corp.store.net,TLD,1,8,-,000_00001_TLD,NDMP_Incremental,9,-,6,0,-,11/02/2012 19:03,01/04/2013 05:00,12/10/2012 08:16,01/07/2013 05:01,00/00/0000 00:00,0,-,00/00/0000 00:00,00/00/0000 00:00,-,-,50,22,Added,by,Media,Manager,-
 E00009,-,HCART,E00009,-,bak901.corp.store.net,TLD,1,16,-,000_00001_TLD,NDMP_Incremental,9,-,6,0,-,11/02/2012 19:03,01/07/2013 05:00,12/10/2012 08:24,01/08/2013 05:02,00/00/0000 00:00,0,-,00/00/0000 00:00,00/00/0000 00:00,-,-,50,22,Added,by,Media,Manager,-
-</sxh>
+</code>
 ==== Barcodes ====
@@ Line 101: / Line 109: @@
   - Command line arguments that instruct the program how to process volumes.
   - A synchronization definition file that instructs the program how to interpret the vmquery output.
+{{networker_sync.png}}
 ==== Example Command Line Arguments ====
-<sxh plain;>
+<code plain;>
-TMSS10Sync -d NBU.ttidef -a -S batch:-password@server < Inventory.csv
+TMSS10Sync -d Volume.ttidef -a -S batch:-password@server < Inventory.csv
-</sxh>
+</code>
 Where:
@@ Line 116: / Line 126: @@
 ==== Example Synchronization Definition ====
-<sxh plain;>
+<code plain;>
 #
 # Set the Customer and Media as literal values as they never change
@@ Line 159: / Line 169: @@
 #
 AddTranslation(REPOSITORY, "*", "LIBR");
-</sxh>
+</code>
 <- :cookbook:dataprotector|Data Protector Sync Cookbook ^ :cookbook:introduction|Cookbook ^ :cookbook:networker|NetWorker Sync Cookbook->
 {{tag> cookbook}}