====== Repository Reports ======
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:
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
-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- ---------------
000004L6 Library Offsite Vault CMnN D45:00:20:10 Unspecified Unassigned Permanent Friday Backup
000005L6 Library Offsite Vault CMnN M13:26 Unspecified Unassigned Permanent Friday Backup
000006L6 Library Offsite Vault CMnN M13:26 Unspecified Unassigned Permanent Monthly January
000009L6 Library Offsite Vault CMnN M3:12 Unspecified Unassigned Permanent Friday Backup
-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- ---------------
=== 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.
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
-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- -------------------
000004L6 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
000005L6 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
000006L6 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
000009L6 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
-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- -------------------
===== 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===
TMSS10ListRepositories -S user:-password@server > report.txt
=== Text File Output ===
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
---- -------------------- ---- -------------------- ---- -------------------- -------- -------- -------- -------- --------
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
TMSS10ListRepositories -S user:-password@server -V "US04.*.*" > report.txt
Only show results for [[object:repository|Repository]] OFFS.
TMSS10ListRepositories -S user:-password@server -V "*.*.*@OFFS" > report.txt
Only show results from [[object:customer|Customer-ID]] US04, [[object:media|Media-ID]] LTO and [[object:repository|Repository]] OFFS
TMSS10ListRepositories -S user:-password@server -V "US04.LTO.*@OFFS" > report.txt
----
[[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 ===
TMSS10MoveList -S user:-password@server > report.txt
=== Text File Output ===
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
------ -------------------- ------------------------------ ------------------------------ ---------------- --------------- -------------------- --------------------------------------------
1 US04.LTO.000001L3 Offsite Vault Library 2019-03-14 11:15 M6:44 Monthly April
2 US04.LTO.000001L5 Offsite Vault Library 2019-03-14 11:15 M6:45 Friday Backup
3 US04.LTO.000001L6 Library Offsite Vault 2019-03-14 11:15 M6:34
4 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
To limit report to only [[object:volume|Volumes]] moving to the [[object:repository|Repository]] OFFS
TMSS10MoveList -S user:-password@server -T "OFFS" > report.txt
To limit report to only [[object:volume|Volumes]] moving from the [[object:repository|Repository]] OFFS
TMSS10MoveList -S user:-password@server -C "OFFS" > report.txt
To limit report to only [[object:volume|Volumes]] moving from the [[object:repository|Repository]] OFFS to [[object:repository|Repository]] "SCRA"
TMSS10MoveList -S user:-password@server -C "OFFS" -T "SCRA" > report.txt
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
TMSS10MoveList -S user:-password@server -C "OFFS" -T "SCRA" -V "US04.LTO.*" > report.txt
{{tag>technote reports cli tapemaster lite}}