TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools

Trace: • operators • tmss10listcustomers • report_tmss10libraryhealth • playground • tmssconfigfile • starting • inventory • report_tmss10listcatalog • tmss10exportfile • simple_management
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/11 23:19] – 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 ======
  
-===== Desktop Programs Inventory Report =====+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 ==== ==== TapeMaster Inventory Reports ====
  
-TapeMaster allows you to export to report one Customer's Media type at a time via the Inventory window or all Customers and Media types using the [[master:tools_global_view|Volume Global View]] function.+[[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.
  
-Using the [[master:tools_global_view|Volume Global View]] function has an added advantage of being able to dynamically filter the data using Customer-ID, Media-ID, Volume-ID, Location, Flags, Move Dates, last User interaction and last Program Interaction before exporting results to a report.+==== Examples ====
  
-{{master:tapemaster_tools_volume_global_view_report.png}}+=== 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.
  
-===== Command Line Inventory Report =====+<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 +Reports can be output in the file formats text, HTML, JSON, PDF (Portrait or Landscape) and CSV.
-  * HTML +
-  * PDF +
-    * Portrait +
-    * Landscape +
-  * CSV+
 ===== Examples ===== ===== Examples =====
  
Line 33: Line 108:
  
 === Command Line Input - Text File === === Command Line Input - Text File ===
-<sxh>+<code>
 TMSS10Inventory -S user:-password@server > report.txt TMSS10Inventory -S user:-password@server > report.txt
-</sxh>+</code>
  
 === Text File Output === === Text File Output ===
-<sxh>+<code>
  
              System: TapeTrack              System: TapeTrack
Line 60: 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 === 
- 
-<sxh> 
-set TMSSREPORTFORMAT=EXCEL 
-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  > report.html 
-</sxh> 
- 
- 
----- 
 ==== TMSS10Inventory Mode 2 ==== ==== TMSS10Inventory Mode 2 ====
  
 ===Command Line Input - Text File === ===Command Line Input - Text File ===
-<sxh>+<code>
 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 139: 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.1552346395.txt.gz · Last modified: 2025/01/21 22:07 (external edit)