Differences

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

--- technote:report:listrepositories [2019/03/13 23:51] – [Examples] 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 ======
-There are several ways to export the current status of Inventory from TapeTrack using:
+There are several ways to export the current status of Inventory based on [[object:repository|Repository]] data from TapeTrack using:
-  * TapeMaster
+  * [[desktop:master|TapeTrack TapeMaster]]
-  * Lite
+  * [[desktop:lite|TapeTrack Lite]]
-  * Command Line programs
+  * [[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 Repository reports that have variable output or on demand requirements.
+TapeMaster and Lite allows dynamic creation of [[object:repository|Repository]] reports that have variable output or on demand requirements.
-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 TMSS10DownloadFile) without the need to create the reports themselves.
+[[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 ======
@@ Line 19: / Line 19: @@
 ==== TapeMaster Repository 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.
+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 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]], Location, [[common:volume_flags|Flags]], Move Dates, Last User Interaction and last Program Interaction before exporting results to a report.
 ==== Examples ====
-=== TapeMaster Inventory Window Repository Report ===
+=== TapeMaster Repository Report ===
-To export report from the TapeMaster Inventory window, filter the displayed [[object:volume|Volumes]] by filtering the Current and/or Target 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.
+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.
-<sxh>
+{{export_inventory.gif}}
-             System: TapeTrack
+Sample export file:
+<code>
+            System: TapeTrack
  Report Description: Volume List
-       Report Notes: Nashville Data Center / LTO Cartridge
+       Report Notes: Los Angeles Data Center - LTO Cartridge
-    Production Time: Thursday, March 14, 2019 - 10:41:22 (AUS Eastern Daylight Time)
+    Production Time: Monday, October 04, 2021 - 12:11:40 (AUS Eastern Daylight Time)
-       Report Width: 107 bytes
+       Report Width: 110 bytes
-ID       Current Location Target Location Flags Move Time Due in      Container  Next Move Description
+ID       Current Location Target Location Flags Move Time    Due in      Container  Next Move Description
--------- ---------------- --------------- ----- --------- ----------- ---------- --------- ---------------
+-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- ---------------
-L5 Library                          CnN             Unspecified Unassigned Permanent Friday Backup
+L6 Library          Offsite Vault   CMnN  D45:00:20:10 Unspecified Unassigned Permanent Friday Backup
-L5 Library                          CnN             Unspecified Unassigned Permanent Friday Backup
+L6 Library          Offsite Vault   CMnN  M13:26       Unspecified Unassigned Permanent Friday Backup
-L6 Library                          CEhnN           Unspecified Unassigned Permanent Monthly January
+L6 Library          Offsite Vault   CMnN  M13:26       Unspecified Unassigned Permanent Monthly January
-L6 Library                          CEhnN           Unspecified Unassigned Permanent Weekly
+L6 Library          Offsite Vault   CMnN  M3:12        Unspecified Unassigned Permanent Friday Backup
-L5 Library                          CEnNt           Unspecified Unassigned Permanent Friday Backup
+-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- ---------------
--------- ---------------- --------------- ----- --------- ----------- ---------- --------- ---------------
-</sxh>
+</code>
 === TapeMaster Volume Global View Repository Report ===
-To export reports from the 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''.
+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 Repository columns.
+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 from the popup window 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.
-<sxh>
+<code>
              System: TapeTrack
  Report Description: Export
-    Production Time: Thursday, March 14, 2019 - 10:37:48 (AUS Eastern Daylight Time)
+    Production Time: Monday, October 04, 2021 - 12:25:52 (AUS Eastern Daylight Time)
-       Report Width: 214 bytes
+       Report Width: 258 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
+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
----------- -------------------- ---- --------------------- --- ------------- ---- ---------- ----- --------- ---------------------- --------- ---------- ------------------- ------------------ ---------------------
+-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- -------------------
-L5   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
+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
-L5   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
+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
-L5   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
+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
-L5   Friday Backup        US04 Nashville Data Center LTO LTO Cartridge LIBR Library    CEnNt Permanent 2018-06-29 (-258 days) Permanent Never      2019-03-04 10:04:01 doco               TapeTrack TapeMaster
+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
-L5   Weekly               US04 Nashville Data Center LTO LTO Cartridge LIBR Library    CnNt  Permanent 2018-08-13 (-213 days) Permanent Never      2018-08-14 12:18:49 doco               TapeTrack TapeMaster
+-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- -------------------
----------- -------------------- ---- --------------------- --- ------------- ---- ---------- ----- --------- ---------------------- --------- ---------- ------------------- ------------------ ---------------------
-</sxh>
+</code>
 ===== Command Line Repository Reports =====
-[[cli:tmss10listrepositories|TMSS10ListRepositories]]
+[[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>
-===== Report Export Formats =====
+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
-Report output format can be either:
+<code>
-  * Text
+TMSS10MoveList -S user:-password@server -C "OFFS" -T "SCRA" -V "US04.LTO.*" > report.txt
-  * HTML
+</code>
-  * PDF
-    * Portrait
-    * Landscape
-  * CSV
+{{tag>technote reports cli tapemaster lite}}