Differences

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

--- cookbook:commvault [2019/04/12 05:11] – [Example Storage Information Report] Scott Cunliffe
+++ cookbook:commvault [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 ===== Storage Information Report =====
-The Storage Information Report is created via the Commvault GUI and output to CSV format, accessable from the reports tab..
+The Storage Information Report is created via the Commvault GUI and output to CSV format, accessible from the reports tab.
+Report Details - General tab.
+Group Volumes by barcode, include all media statuses.
+{{commvault_gui_1.png}}
+Report Details - Libraries tab.
+Include orphaned media, both in and out of all libraries.
+{{commvault_gui_2.png}}
+Report Details - Time Range tab.
+{{commvault_gui_3.png}}
+Report Details - Output tab.
+FTP address is only an example, you will need to add your correct FTP address.
+{{commvault_gui_4.png}}
 ==== Example Storage Information Report ====
-<sxh>
+<code>
 Storage Information Report
@@ Line 41: / Line 63: @@
 L3(R),ULTRIUM V3,N/A,DELL TL-2000 : Swords (LTO-5),SP : Archived : Swords CSO-DB1_Full - 2006 [Weekly Aux Copy (CSO-DB2)],N/A,Infinite,Not Available,N/A,No,N/A,11/22/2014 12:30:42,1,[Appendable]: F,08/25/2008 02:22:34,12/29/2007 10:16:07,125640,(Details about Full/Appendable media)  JobId : 106244 Date : Wed Mar 05 02:12:50 2008,
 L5,ULTRIUM Cleaning Tape,N/A,DELL TL-2001 : Swords (LTO-5),N/A,Cleaning Media,N/A,slot 3,N/A,No,N/A,N/A,1,Cleaning,N/A,03/15/2014 10:42:15,Number of Used/Left:1/48,
-</sxh>
+</code>
 ===== Synchronization =====
@@ Line 56: / Line 78: @@
 ==== Example Command Line Arguments ====
-<sxh plain;>
+<code plain;>
 TMSS10Sync -d default.ttidef -a -S batch:-password@server < commvaultreport.csv
-</sxh>
+</code>
 Where:
@@ Line 69: / Line 91: @@
-<sxh>
+<code>
+#
+# Set delimiter
 SetCSVDelimiter(",");
+# Set Customer-ID
+SetLiteral(CUSTOMER, "1002");
+# Set Media-ID
+SetLiteral(MEDIA, "LTO");
+# Extract values
 Extract(VOLUME, 1, 6, 0);
 Extract(DESCRIPTION, 5, 50, 0);
@@ Line 76: / Line 108: @@
 Extract(WRITETIME, 13, 20, 0);
 Extract(MOVEDATE, 7, 10, 0);
+# Add L5 suffix to barcode value
 AddTranslation(VOLUME, "*", "*L5");
+# Declare date formats
 SetExpiryDateFormat("%%m/%%d/%%Y");
 SetMoveDateFormat("%%m/%%d/%%Y");
-SetWriteTimeFormat("%%m/%%d/%%Y %%H:%%M:%%S");'
+SetWriteTimeFormat("%%m/%%d/%%Y %%H:%%M:%%S");
+# Set start of data
 AddString(START, 0, "A1*");
+# Exclude any line that starts with a space
 AddString(EXCLUSION, 0, " *");
+# Set end of data
 AddString(END, 0, "Notes:*");
-SetLiteral(CUSTOMER, "1002");
-SetLiteral(MEDIA, "LTO");
+</code>
-</sxh>
 <- :cookbook:backupexec|BackupExec Sync Cookbook ^ :cookbook:introduction|Cookbook ^ :cookbook:dataprotector|Data Protector Sync Cookbook->
+{{tag> cookbook}}