TapeTrack Documentation

Because there is more to tape management than you ever realized

User Tools

Site Tools


reports:reconciliation
 

This is an old revision of the document!


TapeTrack Reconciliation Report

The TapeTrack Reconciliation Report is created by the Command Line Program TMSS10Reconcile.

The program runs in 4 sequential phases:

  • Phase 1 Load of the TapeTrack Scan-Map from a Scan File.
  • Phase 2 Reconciliation of the Scan-Map.
  • Phase 3 Listing of unreferenced Scan-Map items.
  • Phase 4 Report Production.

Report Sections

Load of Scan-Map

The purpose of this phase is load a TapeTrack Scan-File and resolved each of the a Scan-File Entries into a Fully Qualified TapeTrack Barcode.

As the Scan-File is loaded, a Scan-Map is created.

Alternatively, rather than loading the Scan-Map from a Scan-File, the TapeTrack Import Engine can be used to load the Scan-Map. This facilitates loading from Fixed Length Reports, CSV Files and ODBC Data Sources.

The Fully Qualified TapeTrack Barcode can be resolved from an Unqualified Barcode or an Extended Attribute.

             System: TapeTrack
 Report Description: Phase 1: Load Scan-Map from Scan-File
    Production Time: Wednesday, November 29, 2017 - 13:25:17 (AUS Eastern Daylight Time)
       Report Width: 149 bytes

 Seq.   Record Barcode                                  Resolved As          Status Notes                                                            
 ------ ------ ---------------------------------------- -------------------- ------ ---------------------------------------------------------------- 
      1      1 US02.LTO.000000L6                        US02.LTO.000000L6    OK                                                                      
      2      2 US02.LTO.000005L6                        US02.LTO.000005L6    OK                                                                      
      3      3 US02.LTO.000024L6                        US02.LTO.000024L6    OK                                                                      
      4      4 US02.LTO.000025L6                        US02.LTO.000025L6    OK                                                                      
      5      5 US02.LTO.000027L6                        US02.LTO.000027L6    OK                                                                      
      6      6 US02.LTO.000028L6                        US02.LTO.000028L6    OK                                                                      
      7      7 US02.LTO.000029L6                        US02.LTO.000029L6    OK                                                                      
      8      8 US02.LTO.000030L6                        US02.LTO.000030L6    OK                                                                      
      9      9 US02.LTO.000031L6                        US02.LTO.000031L6    OK                                                                      
     10     10 US02.LTO.000032L6                        US02.LTO.000032L6    OK                                                                      
     11     11 US02.LTO.000033L6                        US02.LTO.000033L6    OK                                                                      
     12     12 US02.LTO.000034L6                        US02.LTO.000034L6    OK                                                                      
     13     13 US02.LTO.000037L6                        US02.LTO.000037L6    OK                                                                      
     14     14 US02.LTO.000040L6                        US02.LTO.000040L6    OK                                                                      
     15     15 US02.LTO.000041L6                        US02.LTO.000041L6    OK                                                                      
     16     16 US02.LTO.000042L6                        US02.LTO.000042L6    OK                                                                      
     17     17 US02.LTO.000043L6                        US02.LTO.000043L6    OK                                                                      
     18     18 US02.LTO.000044L6                        US02.LTO.000044L6    OK                                                                      
     19     19 US02.LTO.000045L6                        US02.LTO.000045L6    OK                                                                      
     20     20 US02.LTO.000046L6                        US02.LTO.000046L6    OK                                                                      
     21     21 US02.LTO.000047L6                        US02.LTO.000047L6    OK                                                                      
     22     22 US02.LTO.000048L6                        US02.LTO.000048L6    OK                                                                      
     23     23 US02.LTO.000049L6                        US02.LTO.000049L6    OK                                                                      
     24     24 US02.LTO.000050L6                        US02.LTO.000050L6    OK                                                                                                                                     
 ------ ------ ---------------------------------------- -------------------- ------ ---------------------------------------------------------------- 

Reconcile of TapeTrack Volumes

The purpose of this phase is to list all of the Volumes that are either in, moving to, or unexpected in the specified Repository.

The following statuses may result:

  • Reconciled if the Volume is in the Scan-Map and not moving.
  • Reconciled (Confirmed) if the Volume is moving into the specified Repository. The Volume will be Confirmed in the TapeTrack database.
  • Not In Scan-Map if the Volume was previously Confirmed into the specified Repository and is not present in the Scan-Map. An Audit Flag will be placed on the Volume.
  • Pending Confirmation if the Volume is in a Move Status to the specified Repository, is not in the Scan-Map and is not overdue.
  • Overdue at Target if the Volume is in a Move Status to the specified Repository, is not in the Scan-Map and is now overdue.
             System: TapeTrack
 Report Description: Phase 2: Reconcile TapeTrack Volumes against Scan-Map
       Report Notes: Repository OFFS
    Production Time: Wednesday, November 29, 2017 - 13:25:17 (AUS Eastern Daylight Time)
       Report Width: 169 bytes

 Seq.   Barcode              Current Repository   Target Repository    Move Time       Overdue Scanned Move User        Status  Notes                                    
 ------ -------------------- -------------------- -------------------- --------------- ------- ------- ---------------- ------- ---------------------------------------- 
      1 US02.LTO.000000L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      2 US02.LTO.000005L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      3 US02.LTO.000015L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
      4 US02.LTO.000024L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      5 US02.LTO.000025L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      6 US02.LTO.000027L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      7 US02.LTO.000028L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      8 US02.LTO.000029L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
      9 US02.LTO.000030L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     10 US02.LTO.000031L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     11 US02.LTO.000032L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     12 US02.LTO.000033L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     13 US02.LTO.000034L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     14 US02.LTO.000035L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     15 US02.LTO.000037L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     16 US02.LTO.000040L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     17 US02.LTO.000041L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     18 US02.LTO.000042L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     19 US02.LTO.000043L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     20 US02.LTO.000044L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     21 US02.LTO.000045L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     22 US02.LTO.000046L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     23 US02.LTO.000047L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     24 US02.LTO.000048L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     25 US02.LTO.000049L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     26 US02.LTO.000050L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     27 US02.LTO.000051L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     28 US02.LTO.000052L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     29 US02.LTO.000053L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     30 US02.LTO.000054L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     31 US02.LTO.000055L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     32 US02.LTO.000056L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     33 US02.LTO.000057L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     34 US02.LTO.000058L6    Offsite Vault                                             No      Yes                      OK      Reconciled                               
     35 US02.LTO.000065L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     36 US02.LTO.000075L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     37 US02.LTO.000085L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     38 US02.LTO.000095L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     39 US02.LTO.000105L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     40 US02.LTO.000115L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     41 US02.LTO.000125L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     42 US02.LTO.000135L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     43 US02.LTO.000145L6    Library              Offsite Vault           D2:00:28:40  No      No      doco             OK      Pending confirmation                     
     44 US02.LTO.000155L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     45 US02.LTO.000165L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     46 US02.LTO.000175L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     47 US02.LTO.000185L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     48 US02.LTO.000195L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     49 US02.LTO.000205L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     50 US02.LTO.000215L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     51 US02.LTO.000225L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     52 US02.LTO.000235L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     53 US02.LTO.000245L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     54 US02.LTO.000255L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     55 US02.LTO.000265L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     56 US02.LTO.000275L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     57 US02.LTO.000285L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     58 US02.LTO.000295L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     59 US02.LTO.000305L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
     60 US02.LTO.000315L6    Library              Offsite Vault           D2:00:28:39  No      No      doco             OK      Pending confirmation                     
 ------ -------------------- -------------------- -------------------- --------------- ------- ------- ---------------- ------- ---------------------------------------- 

Unreferenced Scan-Map Entries

This report shows Volumes that are in the Scan-Map, but are not known to TapeTrack.

             System: TapeTrack
 Report Description: Phase 3: Unreferenced Scan-Map entries
    Production Time: Wednesday, November 29, 2017 - 13:25:18 (AUS Eastern Daylight Time)
       Report Width: 29 bytes

 Seq.   Barcode              
 ------ -------------------- 
      1 US02.LTO.000315L8
 ------ -------------------- 

Reconciliation Statistics

This report shows the final statistics for the Reconciliation process.

             System: TapeTrack
 Report Description: Phase 4: Reconciliation Statistics
    Production Time: Wednesday, November 29, 2017 - 13:25:18 (AUS Eastern Daylight Time)
       Report Width: 75 bytes

 Metric                                                       Count        
 ------------------------------------------------------------ ------------ 
 Phase 1: Read from Scan-File                                           32 
 Phase 1: Loaded successfully from Scan-File                            32 
 Phase 1: Loaded unsuccessfully from Scan-File                         + 0 
 ------------------------------------------------------------ ------------ 
 Phase 2: Reconciled                                                    32 
 Phase 2: Reconciled (Confirmed)                                         0 
 Phase 2: Confirmation Bypass                                            0 
 Phase 2: Pending confirmation                                          28 
 Phase 2: Out of scope                                                 265 
 Phase 2: Absent from Scan-Map                                         + 0 
 Phase 2: Unexpected in Scan-Map                                       + 0 
 Phase 2: Overdue at subject repository                                + 0 
 Phase 2: Overdue at target repository                                 + 0 
 ------------------------------------------------------------ ------------ 
 Phase 3: Unreferenced Scan-Map items                                  + 0 
 ------------------------------------------------------------ ------------ 
 Phase 4: Total Errors                                                   0 
 ------------------------------------------------------------ ------------ 

Movement Aging Report

This report shows statistics on Volumes that remain in a Move Status after the Reconciliation has completed.

             System: TapeTrack
 Report Description: Phase 4: Movement Aging Report
    Production Time: Wednesday, November 29, 2017 - 13:25:18 (AUS Eastern Daylight Time)
       Report Width: 40 bytes

 Duration             Incoming Outgoing 
 -------------------- -------- -------- 
 less than 1 day             0        0 
 less than 2 days            0        0 
 less than 3 days           28        0 
 less than 4 days            0        0 
 less than 5 days            0        0 
 less than 6 days            0        0 
 less than 7 days            0        0 
 less than 8 days            0        0 
 less than 9 days            0        0 
 9 or more days              0        0 
 -------------------- -------- -------- 
reports/reconciliation.1521412225.txt.gz · Last modified: 2025/01/21 22:07 (external edit)