TapeTrack Documentation

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
======  Reports - Repository ======

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     
-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- --------------- 
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   
-------- ---------------- --------------- ----- ------------ ----------- ---------- --------- --------------- 

</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    
-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- ------------------- 
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 
-------- --------------- ---- ----------------------- --- ------------- ---- ------------- ----- ------------------ --------------------- -------------- ------------------------ ------------------- ------------------- ------------------- ------------------- 

</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
 ------ -------------------- ------------------------------ ------------------------------ ---------------- --------------- -------------------- --------------------------------------------
      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
</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_report tapemaster_report lite}}