Differences

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

--- technote:report:listrepositories [2019/03/11 22:12] – created Scott Cunliffe
+++ technote:report:listrepositories [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
-====== Technote Reports - Repositories ======
+====== Repository Reports ======
-[[cli:tmss10listrepositories|TMSS10ListRepositories]]
+There are several ways to export the current status of Inventory based on [[object:repository|Repository]] data from TapeTrack using:
+  * [[desktop:master|TapeTrack TapeMaster]]
+  * [[desktop:lite|TapeTrack Lite]]
+  * [[cli:introduction|Command Line Utilities]]
+Which method suits your requirement depends on the information required in the report, as well as frequency the reports are required.
+TapeMaster and Lite allows dynamic creation of [[object:repository|Repository]] reports that have variable output or on demand requirements.
+[[object:repository|Repository]] reports that are required on a regular basis can be created using [[cli:TMSS10ListRepositories|TMSS10ListRepositories]] that can then be saved to file, emailed and/or uploaded to the TapeTrack Server allowing clients to download (TapeMaster, Lite or [[cli:TMSS10DownloadFile|TMSS10DownloadFile]]) without the need to create the reports themselves.
+===== Desktop Programs Repository Reports ======
+==== TapeMaster Repository Reports ====
+TapeMaster allows you to export to report one [[object:customer|Customers]] [[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]], Location, [[common:volume_flags|Flags]], Move Dates, Last User Interaction and last Program Interaction before exporting results to a report.
+==== Examples ====
+=== TapeMaster Repository Report ===
+To export report from the TapeMaster Inventory window, filter the displayed [[object:volume|Volumes]] by filtering the Current and/or Target [[object:repository|Repository]],  Select the required volumes, right-click highlighted 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.
+{{export_inventory.gif}}
+Sample export file:
+<code>
+            System: TapeTrack
+ Report Description: Volume List
+       Report Notes: Los Angeles Data Center - LTO Cartridge
+    Production Time: Monday, October 04, 2021 - 12:11:40 (AUS Eastern Daylight Time)
+       Report Width: 110 bytes
+ID       Current Location Target Location Flags Move Time    Due in      Container  Next Move Description
+-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- ---------------
+L6 Library          Offsite Vault   CMnN  D45:00:20:10 Unspecified Unassigned Permanent Friday Backup
+L6 Library          Offsite Vault   CMnN  M13:26       Unspecified Unassigned Permanent Friday Backup
+L6 Library          Offsite Vault   CMnN  M13:26       Unspecified Unassigned Permanent Monthly January
+L6 Library          Offsite Vault   CMnN  M3:12        Unspecified Unassigned Permanent Friday Backup
+-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- ---------------
+</code>
+=== TapeMaster Volume Global View Repository Report ===
+To export reports from the [[master:tools_global_view|Volume Global View]], from the [[master:menu|TapeMaster 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''.
+Filter the displayed [[object:volume|Volumes]] using the Current and/or Target [[object:repository|Repository]] columns.
+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: Monday, October 04, 2021 - 12:25:52 (AUS Eastern Daylight Time)
+       Report Width: 258 bytes
+Volume   Description     ID   Customer                ID  Media         ID   Repository    Flags Last Update (User) Last Update (Program) Next Move Date Expiry Date              Last Move Time      Last Write Time     Last Read Time      Last Update Time
+-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- -------------------
+L6 Friday Backup   US02 Los Angeles Data Center LTO LTO Cartridge OFFS Offsite Vault CMnN  doco               TapeTrack TapeMaster  Permanent      1970-01-01 (-18904 days) 2021-08-20 11:51:30 2021-08-09 13:50:28 Never               2021-10-04 11:58:34
+L6 Friday Backup   US02 Los Angeles Data Center LTO LTO Cartridge OFFS Offsite Vault CMnN  doco               TapeTrack TapeMaster  Permanent      1970-01-01 (-18904 days) 2021-10-04 11:58:14 2021-07-01 13:50:38 2021-08-20 13:50:37 2021-10-04 11:58:34
+L6 Monthly January US02 Los Angeles Data Center LTO LTO Cartridge OFFS Offsite Vault CMnN  doco               TapeTrack TapeMaster  Permanent      1970-01-01 (-18904 days) 2021-10-04 11:58:14 2021-07-01 13:50:51 Never               2021-10-04 11:58:34
+L6 Friday Backup   US02 Los Angeles Data Center LTO LTO Cartridge OFFS Offsite Vault CMnN  doco               TapeTrack TapeMaster  Permanent      1970-01-01 (-18904 days) 2021-10-04 12:08:28 2021-08-16 13:51:43 Never               2021-10-04 12:08:28
+-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- -------------------
+</code>
+===== Command Line Repository Reports =====
+[[cli:tmss10listrepositories|TMSS10ListRepositories]] creates a report listing the current status of each [[object:repository|Repository]] including capacity, usage, incoming Volumes, outgoing Volumes and assigned Slots.
+=== Batch File Or Command Line Input TMSS10ListRepositories===
+<code>
+TMSS10ListRepositories -S user:-password@server > report.txt
+</code>
+=== Text File Output ===
+<code>
+             System: TapeTrack
+ Report Description: Repository Listing
+    Production Time: Monday, October 04, 2021 - 12:28:25 (AUS Eastern Daylight Time)
+       Report Width: 124 bytes
+ ID   Description          ID   Description          ID   Description          Capacity Usage    Incoming Outgoing Assigned
+ ---- -------------------- ---- -------------------- ---- -------------------- -------- -------- -------- -------- --------
+ US02 Los Angeles Data Cen LTO  LTO Cartridge        LIBR Library                     0      232        0        4        0
+ US02 Los Angeles Data Cen LTO  LTO Cartridge        OFFS Offsite Vault               0       10        4        1        0
+ US02 Los Angeles Data Cen LTO  LTO Cartridge        RACK GemTrac                     0        2        1        0        0
+ ---- -------------------- ---- -------------------- ---- -------------------- -------- -------- -------- -------- --------
+                                                          Totals                      0      244        5        5        0
+ ---- -------------------- ---- -------------------- ---- -------------------- -------- -------- -------- -------- --------
+</code>
+To limit the report to one [[object:customer|Customer-ID]], [[object:media|Media-ID]], [[object:repository|Repository-ID]] or a combination of these values use the [[object:volume|Volume]] filter (-V).
+Only show results from [[object:customer|Customer-ID]] US04
+<code>
+TMSS10ListRepositories -S user:-password@server -V "US04.*.*" > report.txt
+</code>
+Only show results for [[object:repository|Repository]] OFFS.
+<code>
+TMSS10ListRepositories -S user:-password@server -V "*.*.*@OFFS" > report.txt
+</code>
+Only show results from [[object:customer|Customer-ID]] US04, [[object:media|Media-ID]] LTO and [[object:repository|Repository]] OFFS
+<code>
+TMSS10ListRepositories -S user:-password@server -V "US04.LTO.*@OFFS" > report.txt
+</code>
+----
+[[cli:TMSS10MoveList|TMSS10MoveList ]] creates a report listing [[object:volume|Volumes]] that are currently moving into or out of displayed [[object:repository|Repositories]] and a total of moving [[object:volume|Volumes]] for each [[object:repository|Repository]].
+=== Batch File Or Command Line Input TMSS10MoveList ===
+<code>
+TMSS10MoveList -S user:-password@server > report.txt
+</code>
+=== Text File Output ===
+<code>
+             System: TapeTrack
+ Report Description: Moving Volumes List
+       Report Notes: Customer(Nashville Data Center) Media Type(LTO Cartridge)
+    Production Time: Thursday, March 14, 2019 - 11:22:23 (AUS Eastern Daylight Time)
+       Report Width: 190 bytes
+ Seq.   Barcode              Current Location               Target Location                Move Time        Time            Container            Attribute
+ ------ -------------------- ------------------------------ ------------------------------ ---------------- --------------- -------------------- --------------------------------------------
+US04.LTO.000001L3    Offsite Vault                  Library                        2019-03-14 11:15           M6:44                      Monthly April
+US04.LTO.000001L5    Offsite Vault                  Library                        2019-03-14 11:15           M6:45                      Friday Backup
+US04.LTO.000001L6    Library                        Offsite Vault                  2019-03-14 11:15           M6:34
+US04.LTO.000002L5    Library                        Offsite Vault                  2019-03-14 11:15           M6:34                      Weekly
+ ------ -------------------- ------------------------------ ------------------------------ ---------------- --------------- -------------------- --------------------------------------------
+             System: TapeTrack
+ Report Description: Movement Directions Report
+       Report Notes: Customer(Nashville Data Center) Media Type(LTO Cartridge)
+    Production Time: Thursday, March 14, 2019 - 11:22:24 (AUS Eastern Daylight Time)
+       Report Width: 54 bytes
+ Current Repository   Target Repository    Total
+ -------------------- -------------------- ----------
+ Library              Offsite Vault                 2
+ Offsite Vault        Library                       2
+</code>
+To limit report to only [[object:volume|Volumes]] moving to the [[object:repository|Repository]] OFFS
+<code>
+TMSS10MoveList -S user:-password@server -T "OFFS" > report.txt
+</code>
+To limit report to only [[object:volume|Volumes]] moving from the [[object:repository|Repository]] OFFS
+<code>
+TMSS10MoveList -S user:-password@server -C "OFFS" > report.txt
+</code>
+To limit report to only [[object:volume|Volumes]] moving from the [[object:repository|Repository]] OFFS to [[object:repository|Repository]] "SCRA"
+<code>
+TMSS10MoveList -S user:-password@server -C "OFFS" -T "SCRA" > report.txt
+</code>
+To limit report to only [[object:volume|Volumes]] moving from the [[object:repository|Repository]] OFFS to [[object:repository|Repository]] "SCRA" for [[object:customer|Customer-ID]] US04 and [[object:media|Media-ID]] LTO
+<code>
+TMSS10MoveList -S user:-password@server -C "OFFS" -T "SCRA" -V "US04.LTO.*" > report.txt
+</code>
+{{tag>technote reports cli tapemaster lite}}