TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace:
technote:report:inventory

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
technote:report:inventory [2019/03/08 02:52] – [Technote Reports - Inventory] Scott Cunliffetechnote:report:inventory [2025/01/21 22:07] (current) – external edit 127.0.0.1
Line 1: Line 1:
-====== Technote Reports - Inventory ======+====== Reports - Inventory ====== 
 + 
 +There are several ways to export the current status of Inventory from TapeTrack using: 
 +  * [[#tapemaster-inventory-reports|TapeMaster]] 
 +  * [[#lite-inventory-reports|Lite]] 
 +  * [[#command-line-inventory-reports|Command Line programs]] 
 + 
 +Which method suits your requirement depends on the information required in the report, as well as frequency the reports are required. 
 + 
 +[[desktop:master|TapeTrack TapeMaster]] and [[desktop:lite|TapeTrack Lite]] allow dynamic creation of Inventory reports that have variable output or on demand requirements.   
 + 
 +Inventory reports that are required on a regular basis can be created using [[cli:TMSS10Inventory|TMSS10Inventory ]]   that can then be saved to file, emailed and/or [[cli:tmss10uploadfile|uploaded to the TapeTrack Server]] allowing clients to download ([[master:upload_files#right-click-functions|TapeMaster]], [[desktop:lite|TapeTrack Lite]] or [[cli:tmss10downloadfile|TMSS10DownloadFile]]) without the need to create the reports themselves. 
 + 
 +===== Desktop Programs Inventory Reports ===== 
 + 
 +==== TapeMaster Inventory Reports ==== 
 + 
 +[[desktop:master|TapeTrack TapeMaster]] allows you to export to report one [[object:customer|Customer's]] [[object:media|Media Type]] at a time via the Inventory window or all [[object:customer|Customers]] and [[object:media|Media Types]] using the [[master:tools_global_view|Volume Global View]] function. 
 + 
 +Using the [[master:tools_global_view|Volume Global View]] function has an added advantage of being able to dynamically filter the data using [[object:customer|Customer-ID]], [[object:media|Media-ID]], [[object:volume|Volume-ID]], [[object:repository|Location]], [[common:volume_flags|Flags]], Move Dates, last User interaction and last Program Interaction before exporting results to a report. 
 + 
 +==== Examples ==== 
 + 
 +=== TapeMaster Inventory Window Report === 
 + 
 +To export report from the TapeMaster Inventory window, select the required [[object:volume|Volumes]], press Ctrl+E, or right-click and select ''Export''.  Select the required report format from the popup window and click OK. 
 + 
 +<code> 
 + 
 +             System: TapeTrack 
 + Report Description: Volume List 
 +       Report Notes: Nashville Data Center / LTO Cartridge 
 +    Production Time: Thursday, March 14, 2019 - 09:45:40 (AUS Eastern Daylight Time) 
 +       Report Width: 119 bytes 
 + 
 +ID         Current Location Target Location Flags   Move Time    Due in      Container  Next Move Description           
 +---------- ---------------- --------------- ------- ------------ ----------- ---------- --------- --------------------  
 +000001L3   Offsite Vault                    ChnNO                Unspecified Unassigned Permanent Monthly April         
 +000001L5   L5 GemTrac                       CnN                  Unspecified Unassigned Permanent Friday Backup         
 +000001L6   Offsite Vault                    CnO                  Unspecified Unassigned Permanent                       
 +000002L5   Offsite Vault    Library         CMnN    D33:19:51:59 Unspecified Unassigned Permanent Weekly                
 +000003L5   Scratch Volumes                  CnNZ                 Unspecified Unassigned Permanent Weekly                
 +---------- ---------------- --------------- ------- ------------ ----------- ---------- --------- --------------------  
 +</code> 
 + 
 +=== TapeMaster Volume Global View Report === 
 + 
 +To export reports from the [[master:tools_global_view|Volume Global View]], from the Main Menu select ''Tools'' -> ''Volume Global View''.  From the popup, if required,  enter any filters (including extended Attribute) to narrow down the displayed results and click ''OK''. 
 + 
 +Select the required [[object:volume|Volumes]] and press Ctrl+E, or right-click and select ''Export''.  Select the required report format (Text, HTML, PDF (Portrait or Landscape) or CSV) from the popup window and click OK. 
 + 
 +<code> 
 + 
 +             System: TapeTrack 
 + Report Description: Export 
 +    Production Time: Thursday, March 14, 2019 - 10:10:36 (AUS Eastern Daylight Time) 
 +       Report Width: 222 bytes 
 + 
 +Volume     Description          ID   Customer              ID   Media         ID   Repository      Flags   Next Move Last Move              Expiry    Last Write Last Update - Time  Last Update - User Last Update - Program  
 +---------- -------------------- ---- --------------------- ---- ------------- ---- --------------- ------- --------- ---------------------- --------- ---------- ------------------- ------------------ ---------------------  
 +000001L5   Friday Backup        US04 Nashville Data Center LTO  LTO Cartridge TEMP L5 GemTrac      CnN     Permanent 2019-02-06 (-36 days)  Permanent Never      2019-02-06 11:20:26 doco               TapeTrack TapeMaster   
 +000001L6                        US04 Nashville Data Center LTO  LTO Cartridge OFFS Offsite Vault   CnO     Permanent 2019-02-06 (-36 days)  Permanent Never      2019-02-06 11:20:26 doco               TapeTrack TapeMaster   
 +000002L5   Weekly               US04 Nashville Data Center LTO  LTO Cartridge LIBR Library         CMnN    Permanent 2019-02-08 (-34 days)  Permanent Never      2019-02-08 13:53:41 doco               TapeTrack TapeMaster   
 +000003L5   Weekly               US04 Nashville Data Center LTO  LTO Cartridge SCRA Scratch Volumes CnNZ    Permanent 2019-02-06 (-36 days)  Permanent Never      2019-02-06 11:19:44 doco               TapeTrack TapeMaster   
 +000004L5   Friday Backup        US04 Nashville Data Center LTO  LTO Cartridge LIBR Library         CnN     Permanent 2018-08-14 (-212 days) Permanent Never      2018-08-14 12:18:37 doco               TapeTrack TapeMaster   
 +---------- -------------------- ---- --------------------- ---- ------------- ---- --------------- ------- --------- ---------------------- --------- ---------- ------------------- ------------------ ---------------------  
 +</code> 
 +{{:master:tapemaster_tools_volume_global_view_report_export.png}} 
 + 
 +==== Lite Inventory Reports ==== 
 + 
 +[[desktop:lite|TapeTrack Lite's]] [[lite:function_volume_management|Volume Management]] function displays [[object:volume|Volumes]] from the selected Customer's Media type.   
 + 
 +Required [[object:volume|Volumes]] can be selected by range clicking (Shift+Click and Ctrl+Click) or select all [[object:volume|Volumes]] by right-clicking and ''Select'' -> ''All''. 
 + 
 +Once the [[object:volume|Volumes]] are selected, right-click and select ''Export'' (or Ctrl+E) to export Inventory to chosen file format. 
 + 
 +<code> 
 + 
 +             System: TapeTrack 
 + Report Description: Export 
 +    Production Time: Thursday, March 14, 2019 - 09:45:40 (AUS Eastern Daylight Time) 
 +       Report Width: 55 bytes 
 + 
 +Volume-ID Location      Description          Next move  
 +--------- ------------- -------------------- ---------  
 +000001L3   Offsite Vault                     Permanent        
 +000001L5   GemTrac                           Permanent         
 +000001L6   Offsite Vault                     Permanent                       
 +000002L5   Offsite Vault                     Permanent                 
 +000003L5   Scratch Volumes                   Permanent  
 +--------- ------------- -------------------- ---------  
 +</code> 
 +===== Command Line Inventory Reports =====
  
 [[cli:tmss10inventory|TMSS10Inventory]] produces an Inventory Report of all selected [[object:volume|Volumes]]. [[cli:tmss10inventory|TMSS10Inventory]] produces an Inventory Report of all selected [[object:volume|Volumes]].
  
 The Inventory report can be output in two modes: The Inventory report can be output in two modes:
-  * Mode 1 (default) will produce a report with the values: Sequence, Barcode, Location, Repository, Next Move, Days, Last Move, GDup, CDup and Container.+  * Mode 1 (default) will produce a report with the values: Sequence, Barcode, Location, Repository, Next Move, Days, Last Move, GDup (Global Duplicate), CDup (Customer Duplicate) and Container.
   * Mode 2 will produce a report with the values: Sequence, Customer, Media, Total and Moving total.   * Mode 2 will produce a report with the values: Sequence, Customer, Media, Total and Moving total.
  
-Report output format can be either: 
-  * Text 
-  * HTML 
-  * PDF 
-    * Portrait 
-    * Landscape 
-  * CSV 
-===== TMSS10Inventory Mode 1===== 
  
-==== Command Line Input - Text File ==== +Reports can be output in the file formats text, HTML, JSON, PDF (Portrait or Landscape) and CSV. 
-<sxh> +===== Examples ===== 
-TMSS10Inventory -S user:-password@server  + 
-</sxh>+ 
 +==== TMSS10Inventory Mode 1==== 
 + 
 +=== Command Line Input - Text File === 
 +<code> 
 +TMSS10Inventory -S user:-password@server > report.txt 
 +</code>
  
-==== Text File Output ==== +=== Text File Output === 
-<sxh>+<code>
  
              System: TapeTrack              System: TapeTrack
Line 44: Line 135:
      11 US04.LTO.000006L6    No-Alloc [0]                   Library                                              2018-08-10 09:35:26    2    1                      Weekly                               11 US04.LTO.000006L6    No-Alloc [0]                   Library                                              2018-08-10 09:35:26    2    1                      Weekly                         
      12 US04.LTO.000007L5    No-Alloc [0]                   Scratch Volumes                                      2019-02-06 11:19:40    5    1                      Friday Backup                        12 US04.LTO.000007L5    No-Alloc [0]                   Scratch Volumes                                      2019-02-06 11:19:40    5    1                      Friday Backup                  
-     13 US04.LTO.000007L6    No-Alloc [0]                   Scratch Volumes                                      2019-02-06 11:19:40    2    1                      Weekly                          +------ -------------------- ------------------------------ ------------------------------ ---------- ---------- ------------------- ---- ---- -------------------- ------------------------------ 
-     14 US04.LTO.000008L5    No-Alloc [0]                   Scratch Volumes                                      2019-02-06 11:19:40    5    1                      Friday Backup                   +
-     15 US04.LTO.000008L6    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:19:21    1    1                      Monthly February                +
-     16 US04.LTO.000009L5    No-Alloc [0]                   Library                                              2018-06-29 09:43:18    5    1                      Friday Backup                   +
-     17 US04.LTO.000009L6    No-Alloc [0]                   Library                                              2018-06-29 09:43:18    2    1                      Monthly March                   +
-     18 US04.LTO.000010L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:19:21    5    1                      Friday Backup                   +
-     19 US04.LTO.000010L6    No-Alloc [0]                   Library                                              2018-08-13 12:59:36    2    1                      Weekly                          +
-     20 US04.LTO.000011L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:19:21    4    1                                                      +
-     21 US04.LTO.000012L5    No-Alloc [0]                   Library                                              2018-08-13 12:59:36    5    1                      Weekly                          +
-     22 US04.LTO.000013L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:19:21    4    1                                                      +
-     23 US04.LTO.000014L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:20:00    4    1                                                      +
-     24 US04.LTO.000015L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:20:00    4    1                                                      +
-     25 US04.LTO.000016L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:20:00    4    1                                                      +
-     26 US04.LTO.000017L5    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:20:00    4    1                                                      +
-     27 US04.LTO.00001L6     No-Alloc [0]                   Library                                                                     1    1                                                      +
-     28 US04.LTO.000123L6    No-Alloc [0]                   Library                                                                     1    1                                                      +
-     29 US04.LTO.000124L6    No-Alloc [0]                   Offsite Vault                                        2019-02-06 11:19:22    1    1                                                      +
- ------ -------------------- ------------------------------ ------------------------------ ---------- ---------- ------------------- ---- ---- -------------------- ------------------------------ +
  
-</sxh>+</code>
  
----- +Alternative Output Formats TMSS10Inventory Mode 1 Examples:\\ 
- +[[technote:report:inventory:report_examples#command-line-input---pdf-file|TMSS10Inventory Mode 1 PDF File Output]] \\ 
-==== Command Line Input - PDF File ==== +[[technote:report:inventory:report_examples#command-line-input---excel-file|TMSS10Inventory Mode 1 Excel File Output]] \\ 
- +[[technote:report:inventory:report_examples#command-line-input---html-file|TMSS10Inventory Mode 1 HTML File Output]] \\
-<sxh> +
-set TMSSREPORTFORMAT=PDF +
-set TMSSPDFORIENTATION=landscape +
-TMSS10Inventory -S user:-password@server   +
-</sxh> +
- +
-==== PDF File Output ==== +
- +
-{{technote:tmss10inventory_pdf2.png}}+
  
 ---- ----
  
-==== Command Line Input - Excel File ====+==== TMSS10Inventory Mode 2 ====
  
-<sxh> +===Command Line Input - Text File === 
-set TMSSREPORTFORMAT=EXCEL +<code>
-TMSS10Inventory -S user:-password@server   +
-</sxh> +
- +
-==== Excel File Output ==== +
- +
-{{technote:tmss10inventory_excel.png}} +
- +
----- +
- +
-==== Command Line Input - HTML File ==== +
- +
-<sxh> +
-set TMSSREPORTFORMAT=HTML +
-TMSS10Inventory -S user:-password@server   +
-</sxh> +
- +
- +
----- +
-===== TMSS10Inventory Mode 2 ===== +
- +
-====Command Line Input - Text File ==== +
-<sxh>+
 TMSS10Inventory -S user:-password@server -M 2  TMSS10Inventory -S user:-password@server -M 2 
-</sxh>+</code>
  
-==== Text File Output ====+=== Text File Output ===
  
-<sxh>+<code>
  
              System: TapeTrack              System: TapeTrack
Line 123: Line 166:
       1 Nashville Data Center                    LTO Cartridge                29          4        1 Nashville Data Center                    LTO Cartridge                29          4 
  
-</sxh>+</code>
  
----- +Alternative Output Formats TMSS10Inventory Mode 1 Examples:\\ 
- +[[technote:report:inventory:report_examples#command-line-input---pdf-file-mode-2|TMSS10Inventory Mode 2 PDF File Output]] \\ 
-==== Command Line Input - PDF File ==== +[[technote:report:inventory:report_examples#command-line-input---excel-file-mode-2|TMSS10Inventory Mode 2 Excel File Output]] \\ 
- +[[technote:report:inventory:report_examples#command-line-input---html-file-mode-2|TMSS10Inventory Mode 2 HTML File Output]] \\
-<sxh> +
-set TMSSREPORTFORMAT=PDF +
-set TMSSPDFORIENTATION=landscape +
-TMSS10Inventory -S user:-password@server -M 2 +
-</sxh> +
- +
-==== PDF File Output ==== +
- +
-{{technote:tmss10inventory_mode2_pdf.png}}+
  
 ---- ----
  
-==== Command Line Input - Excel File ==== +{{tag> reports technote cli tapemaster}}
-<sxh> +
-set TMSSREPORTFORMAT=EXCEL +
-TMSS10Inventory -S user:-password@server -M 2  +
-</sxh> +
- +
-==== Excel File Output ==== +
- +
-{{technote:tmss10inventory_mode2_excel.png}} +
- +
----- +
- +
-==== Command Line Input - HTML File ==== +
- +
-<sxh> +
-set TMSSREPORTFORMAT=HTML +
-TMSS10Inventory -S user:-password@server -M 2 +
-</sxh>+
technote/report/inventory.1552013529.txt.gz · Last modified: 2025/01/21 22:07 (external edit)