| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| technote:report:inventory [2019/03/12 00:08] – [Command Line Inventory Report] Scott Cunliffe | technote:report:inventory [2025/01/21 22:07] (current) – external edit 127.0.0.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 Customer-ID, Media-ID, Volume-ID, Location, 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 [[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 |
| |
| {{master:tapemaster_tools_volume_global_view_report_export.png}} | 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 ==== | ==== Lite Inventory Reports ==== |
| |
| Lite's [[lite:function_volume_management|Volume Management]] function displays [[object:volume|Volumes]] from the selected Customer's Media type. | [[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''. | 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. | Once the [[object:volume|Volumes]] are selected, right-click and select ''Export'' (or Ctrl+E) to export Inventory to chosen file format. |
| |
| ===== Command Line Inventory Report ===== | <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]]. |
| |
| |
| ===== Report Export Formats ===== | Reports can be output in the file formats text, HTML, JSON, PDF (Portrait or Landscape) and CSV. |
| | |
| Report output format can be either: | |
| * Text | |
| * HTML | |
| * PDF | |
| * Portrait | |
| * Landscape | |
| * CSV | |
| ===== Examples ===== | ===== Examples ===== |
| |
| |
| === 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 |
| ------ -------------------- ------------------------------ ------------------------------ ---------- ---------- ------------------- ---- ---- -------------------- ------------------------------ | ------ -------------------- ------------------------------ ------------------------------ ---------- ---------- ------------------- ---- ---- -------------------- ------------------------------ |
| |
| </sxh> | </code> |
| |
| ---- | Alternative Output Formats TMSS10Inventory Mode 1 Examples:\\ |
| [[technote:report:inventory:report_examples|PDF File Output]] \\ | [[technote:report:inventory:report_examples#command-line-input---pdf-file|TMSS10Inventory Mode 1 PDF File Output]] \\ |
| [[technote:report:inventory:report_examples|Excel File Output]] \\ | [[technote:report:inventory:report_examples#command-line-input---excel-file|TMSS10Inventory Mode 1 Excel File Output]] \\ |
| [[technote:report:inventory:report_examples|HTML File Output]] \\ | [[technote:report:inventory:report_examples#command-line-input---html-file|TMSS10Inventory Mode 1 HTML File Output]] \\ |
| |
| ---- | ---- |
| | |
| ==== 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 |
| 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> | |
