====== 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.
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
---------- ---------------- --------------- ------- ------------ ----------- ---------- --------- --------------------
=== 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.
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
---------- -------------------- ---- --------------------- ---- ------------- ---- --------------- ------- --------- ---------------------- --------- ---------- ------------------- ------------------ ---------------------
{{: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.
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
--------- ------------- -------------------- ---------
===== Command Line Inventory Reports =====
[[cli:tmss10inventory|TMSS10Inventory]] produces an Inventory Report of all selected [[object:volume|Volumes]].
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 (Global Duplicate), CDup (Customer Duplicate) and Container.
* Mode 2 will produce a report with the values: Sequence, Customer, Media, Total and Moving total.
Reports can be output in the file formats text, HTML, JSON, PDF (Portrait or Landscape) and CSV.
===== Examples =====
==== TMSS10Inventory Mode 1====
=== Command Line Input - Text File ===
TMSS10Inventory -S user:-password@server > report.txt
=== Text File Output ===
System: TapeTrack
Report Description: Inventory List
Report Notes: Customer(Nashville Data Center) Media Type(LTO Cartridge)
Production Time: Wednesday, February 06, 2019 - 11:38:28 (AUS Eastern Daylight Time)
Report Width: 195 bytes
Seq. Barcode Location Repository Expiry Next Move Last Move GDup CDup Container Attribute
------ -------------------- ------------------------------ ------------------------------ ---------- ---------- ------------------- ---- ---- -------------------- ------------------------------
1 US04.LTO.000001L3 No-Alloc [0] Offsite Vault 2018-08-15 10:53:59 1 1 Monthly April
2 US04.LTO.000001L5 No-Alloc [0] L5 GemTrac 2019-02-06 11:20:17 5 1 Friday Backup
3 US04.LTO.000001L6 No-Alloc [0] Offsite Vault 2019-02-06 11:19:21 1 1
4 US04.LTO.000002L5 No-Alloc [0] Offsite Vault 2019-02-06 11:19:21 5 1 Weekly
5 US04.LTO.000003L5 No-Alloc [0] Scratch Volumes 2019-02-06 11:19:40 5 1 Weekly
6 US04.LTO.000004L5 No-Alloc [0] Library 2018-08-14 12:18:33 5 1 Friday Backup
7 US04.LTO.000004L6 No-Alloc [0] Scratch Volumes 2019-02-06 11:19:40 2 1 Weekly
8 US04.LTO.000005L5 No-Alloc [0] Library 2018-08-14 12:18:33 5 1 Friday Backup
9 US04.LTO.000005L6 No-Alloc [0] Library 2018-08-10 09:35:26 2 1 Monthly January
10 US04.LTO.000006L5 No-Alloc [0] Scratch Volumes 2019-02-06 11:19:40 5 1 Friday Backup
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
------ -------------------- ------------------------------ ------------------------------ ---------- ---------- ------------------- ---- ---- -------------------- ------------------------------
Alternative Output Formats TMSS10Inventory Mode 1 Examples:\\
[[technote:report:inventory:report_examples#command-line-input---pdf-file|TMSS10Inventory Mode 1 PDF File Output]] \\
[[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]] \\
----
==== TMSS10Inventory Mode 2 ====
===Command Line Input - Text File ===
TMSS10Inventory -S user:-password@server -M 2
=== Text File Output ===
System: TapeTrack
Report Description: Volume Inventory Extract
Production Time: Wednesday, February 06, 2019 - 12:03:25 (AUS Eastern Daylight Time)
Report Width: 92 bytes
Seq. Customer Media Total Moving
------ ---------------------------------------- -------------------- ---------- ----------
1 Nashville Data Center LTO Cartridge 29 4
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]] \\
[[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]] \\
----
{{tag> reports technote cli tapemaster}}