| |
| reports:reconciliation [2018/03/19 00:41] – [Unreferenced Scan-Map Entries] Scott Cunliffe | reports:reconciliation [2025/01/21 22:07] (current) – external edit 127.0.0.1 |
|---|
| The program runs in 4 sequential phases: | The program runs in 4 sequential phases: |
| |
| * **Phase 1** Load of the TapeTrack Scan-Map from a Scan File. | * **Phase 1** Load of the TapeTrack Scan-Map from a Scan-File. |
| * **Phase 2** Reconciliation of the Scan-Map. | * **Phase 2** Reconciliation of the Scan-Map. |
| * **Phase 3** Listing of unreferenced Scan-Map items. | * **Phase 3** Listing of unreferenced Scan-Map items. |
| {{reports:reports_tmss10reconcile_tapemaster_customer_status.png}} | {{reports:reports_tmss10reconcile_tapemaster_customer_status.png}} |
| |
| ==== Scan File ==== | ==== Scan-File ==== |
| |
| {{reports:reports_tmss10reconcile_tapemaster_scanfile.png}} | {{reports:reports_tmss10reconcile_tapemaster_scanfile.png}} |
| ==== Load of Scan-Map ==== | ==== Load of Scan-Map ==== |
| |
| The purpose of this phase is load a [[concepts:scan-file|TapeTrack Scan-File]] and resolved each of the a Scan-File Entries into a [[concepts:fully_qualified_barcode|Fully Qualified TapeTrack Barcode]]. | The purpose of this phase is to load a [[concepts:scan-file|TapeTrack Scan-File]] and resolve each of the a Scan-File Entries into a [[concepts:qualified_barcode|Fully Qualified TapeTrack Barcode]]. |
| |
| As the Scan-File is loaded, a [[concepts:scan-map|Scan-Map]] is created. | As the [[concepts:scan-file|Scan-File]] is loaded, a [[concepts:scan-map|Scan-Map]] is created. |
| |
| Alternatively, rather than loading the Scan-Map from a Scan-File, the [[subsystem:importengine|TapeTrack Import Engine]] can be used to load the Scan-Map. This facilitates loading from Fixed Length Reports, CSV Files and ODBC Data Sources. | Alternatively, rather than loading the [[concepts:scan-map|Scan-Map]] from a Scan-File, the TapeTrack Import Engine can be used to load the [[concepts:scan-map|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 [[concepts:unqualified_barcode|Unqualified Barcode]] or an [[concepts:extended_attribute|Extended Attribute]]. | The Fully Qualified TapeTrack Barcode can be resolved from an [[concepts:qualified_barcode|Unqualified Barcode]] or an [[concepts:extended_attribute|Extended Attribute]]. |
| <code> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 1: Load Scan-Map from Scan-File | Report Description: Phase 1: Load Scan-Map from Scan-File |
| ==== Reconcile of TapeTrack Volumes ==== | ==== 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 purpose of this phase is to list all of the [[:object:volume|Volumes]] that are either in, moving to, or unexpected in the specified [[:object:repository|Repository]]. |
| |
| The following statuses may result: | The following statuses may result: |
| |
| * **Reconciled** if the Volume is in the Scan-Map and not moving. | * **Reconciled** if the [[:object:volume|Volume]] is in the Target [[:object:repository|Repository]], is in the [[concepts:scan-map|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. | * **Reconciled (Confirmed)** if the [[:object:volume|Volume]] is moving into the specified [[:object:repository|Repository]] and is in the [[concepts:scan-map|Scan-Map]]. The [[:object:volume|Volume]] will be Confirmed into the [[:object:volume|Volume's]] Target Repository 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. | * **Absent from Scan-Map** if the [[:object:volume|Volume]] is confirmed into the specified [[:object:repository|Repository]] and is not present in the [[concepts:scan-map|Scan-Map]]. An Audit Flag will be assigned to the [[:object:volume|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. | * **Pending Confirmation** if the [[:object:volume|Volume]] is in a move status out from the specified [[:object:repository|Repository]] and is not overdue at the Target [[:object:repository|Repository]]. |
| * **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. | * **Overdue at Target** if the [[:object:volume|Volume]] is in a move status to the specified [[:object:repository|Repository]], is not in the Scan-Map and is now overdue at the Target [[:object:repository|Repository]]. |
| | * **Unexpected in Scan-Map** Present in the [[concepts:scan-map|Scan-Map]] but not present at, or moving to, the Target [[:object:repository|Repository]]. |
| |
| <note tip>Report headings and spacing have been edited to fit information on web formatting</note> | <note>Report headings and spacing have been edited to fit information on web formatting</note> |
| |
| <code> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 2: Reconcile TapeTrack Volumes against Scan-Map | Report Description: Phase 2: Reconcile TapeTrack Volumes against Scan-Map |
| -- ------------------ -------------- ----------- ----------- ------- ------- ------ -----------------------</code> | -- ------------------ -------------- ----------- ----------- ------- ------- ------ -----------------------</code> |
| |
| | Following the example data at the top of page we have: |
| | * [[:object:volume|Volumes]] ''000002L5'' and ''000009L6'' are referenced as **Reconciled** as they are in the [[concepts:scan-map|Scan-Map]], and confirmed in the current [[:object:repository|Repository]] (Offsite Vault). |
| | * [[:object:volume|Volumes]] ''000003L5'', ''000004L6'' and ''000005L6'' are referenced as **Pending confirmation** as they are in the [[concepts:scan-map|Scan-Map]], and in a move from the current [[:object:repository|Repository]] but not yet confirmed at the target [[:object:repository|Repository]]. |
| | * [[:object:volume|Volumes]] ''000008L6'' is referenced as **Absent from Scan-Map** as it appears in TapeTrack as at the current [[:object:repository|Repository]] but is absent from the [[concepts:scan-map|Scan-Map]]. This shows the [[:object:volume|Volume]] is either somewhere it shouldn't be or is missing and as such is given a status of **NOT-OK** and is given an audit flag for further investigation. |
| | * [[:object:volume|Volume]] ''000010L6'' is referenced as **Unexpected in Scan-Map** as it is present in the [[concepts:scan-map|Scan-Map]] as being at the current [[:object:repository|Repository]] but shown in TapeTrack as being confirmed at another [[:object:repository|Repository]]. As such is given a status of **NOT-OK** and is given an audit flag for further investigation. |
| | |
| | <note tip>Status strings may be customized using [[reports:reconciliation_tmssreconciletext|TMSSRECONCILETEXT]] variables.</note> |
| ==== Unreferenced Scan-Map Entries ==== | ==== Unreferenced Scan-Map Entries ==== |
| This report shows Volumes that are in the Scan-Map, but are not known to TapeTrack. | This report shows [[:object:volume|Volumes]] that are in the [[concepts:scan-map|Scan-Map]], but are not known to TapeTrack. |
| <code> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 3: Unreferenced Scan-Map entries | Report Description: Phase 3: Unreferenced Scan-Map entries |
| ------ -------------------- | ------ -------------------- |
| </code> | </code> |
| | |
| | Reasons for this error could be: |
| | * [[:object:volume|Volume]] does not belong to you but has been included with your [[:object:volume|Volumes]] by operator error. |
| | * Manually produced Scan-File with a typo on a [[:object:volume|Volume]] ID. |
| | * [[:object:volume|Volume]] added to inventory but not entered into TapeTrack. |
| |
| ==== Reconciliation Statistics ==== | ==== Reconciliation Statistics ==== |
| This report shows the final statistics for the Reconciliation process. | This report shows the final statistics for the Reconciliation process. |
| |
| <code> | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 4: Reconciliation Statistics | Report Description: Phase 4: Reconciliation Statistics |
| Production Time: Wednesday, November 29, 2017 - 13:25:18 (AUS Eastern Daylight Time) | Production Time: Monday, March 19, 2018 - 10:21:34 (AUS Eastern Daylight Time) |
| Report Width: 75 bytes | Report Width: 75 bytes |
| |
| Metric Count | Metric Count |
| ------------------------------------------------------------ ------------ | ------------------------------------------------------------ ------------ |
| Phase 1: Read from Scan-File 32 | Phase 1: Read from Scan-File 7 |
| Phase 1: Loaded successfully from Scan-File 32 | Phase 1: Loaded successfully from Scan-File 7 |
| Phase 1: Loaded unsuccessfully from Scan-File + 0 | Phase 1: Loaded unsuccessfully from Scan-File + 0 |
| ------------------------------------------------------------ ------------ | ------------------------------------------------------------ ------------ |
| Phase 2: Reconciled 32 | Phase 2: Reconciled 2 |
| Phase 2: Reconciled (Confirmed) 0 | Phase 2: Reconciled (Confirmed) 0 |
| Phase 2: Confirmation Bypass 0 | Phase 2: Confirmation Bypass 0 |
| Phase 2: Pending confirmation 28 | Phase 2: Pending confirmation 3 |
| Phase 2: Out of scope 265 | Phase 2: Out of scope 3 |
| Phase 2: Absent from Scan-Map + 0 | Phase 2: Absent from Scan-Map + 1 |
| Phase 2: Unexpected in Scan-Map + 0 | Phase 2: Unexpected in Scan-Map + 1 |
| Phase 2: Overdue at subject repository + 0 | Phase 2: Overdue at subject repository + 0 |
| Phase 2: Overdue at target repository + 0 | Phase 2: Overdue at target repository + 0 |
| ------------------------------------------------------------ ------------ | ------------------------------------------------------------ ------------ |
| Phase 3: Unreferenced Scan-Map items + 0 | Phase 3: Unreferenced Scan-Map items + 1 |
| ------------------------------------------------------------ ------------ | ------------------------------------------------------------ ------------ |
| Phase 4: Total Errors 0 | Phase 4: Total Errors 3 |
| ------------------------------------------------------------ ------------ | ------------------------------------------------------------ ------------ |
| </code> | </code> |
| | |
| | === Phase 1 === |
| | |
| | Reads in [[:object:volume|Volume-ID's]] from the Scan-File, parses them (depending on format) into Customer-ID, Media-ID and [[:object:volume|Volume-ID]]. Metrics are then displayed as the number of [[:object:volume|Volumes]] successfully and unsuccessfully loaded ready for reconciliation in phase two. |
| | |
| | With the example data, all 7 entries were successfully loaded as fully qualified barcodes from the Scan-File into the Scan-Map ready for reconciliation. |
| | |
| | === Phase 2 === |
| | |
| | <note tip>Status strings (Reconciled, Reconciled (Confirmed) etc) may be customized using [[reports:reconciliation_tmssreconciletext|TMSSRECONCILETEXT]] variables </note> |
| | |
| | * **Reconciled** shows number of [[:object:volume|Volumes]] present in Scan-Map and confirmed at subject [[:object:repository|Repository]]. \\ |
| | * **Reconciled (Confirmed)** shows number of [[:object:volume|Volumes]] confirmed into subject [[:object:repository|Repository]] that were in a move to there and present in Scan-Map. \\ |
| | * **Confirmation Bypass** (set as an Attribute in [[cli:tmss10reconcile|TMSS10Reconcile]]) shows the number of [[:object:volume|Volumes]] moving to subject [[:object:repository|Repository]] and present in Scan-Map but not confirmed. \\ |
| | * **Pending confirmation** shows number of [[:object:volume|Volumes]] present in Scan-Map, in a move status out of subject [[:object:repository|Repository]] and yet to be confirmed at target [[:object:repository|Repository]]. \\ |
| | * **Out of scope** shows the number of [[:object:volume|Volumes]] in the customers inventory that are not referenced in the Scan-Map and are listed in TapeTrack as being not confirmed in, moving to or from the subject [[:object:repository|Repository]]. \\ |
| | * **Absent from Scan-Map** show the number of [[:object:volume|Volumes]] expected to be either in, moving to or moving from the subject [[:object:repository|Repository]] that are not listed in the Scan-Map. \\ |
| | * **Unexpected in Scan-Map** shows the number of [[:object:volume|Volumes]] present in the Scan-Map that, in TapeTrack, are not present in, moving to or moving from the subject [[:object:repository|Repository]]. \\ |
| | * **Overdue at subject repository** shows the number of [[:object:volume|Volumes]] present in the Scan-Map that are moving to the subject [[:object:repository|Repository]] but have exceeded the time threshold to complete the move. \\ |
| | * **Overdue at target repository** shows the number of [[:object:volume|Volumes]] present in the Scan-Map that are moving from the subject [[:object:repository|Repository]] but have exceeded the target [[:object:repository|Repository]]'s time threshold to complete the move. |
| | |
| | === Phase 3 === |
| | |
| | **Unreferenced Scan-Map Items** shows the number of [[:object:volume|Volumes]] that are present in the [[concepts:scan-map|Scan-Map]] but don't exist within the customers target media. |
| | |
| | === Phase 4 === |
| | |
| | **Total Errors** shows the total accumulated errors from the reconciliation process. |
| |
| ==== Movement Aging Report ==== | ==== Movement Aging Report ==== |
| This report shows statistics on Volumes that remain in a Move Status after the Reconciliation has completed. | |
| |
| <code> | This report shows statistics on [[:object:volume|Volumes]] that remain in a move status after the reconciliation has completed. |
| | |
| | <code plain;> |
| System: TapeTrack | System: TapeTrack |
| Report Description: Phase 4: Movement Aging Report | Report Description: Phase 4: Movement Aging Report |
| Production Time: Wednesday, November 29, 2017 - 13:25:18 (AUS Eastern Daylight Time) | Production Time: Monday, March 19, 2018 - 10:21:34 (AUS Eastern Daylight Time) |
| Report Width: 40 bytes | Report Width: 40 bytes |
| |
| Duration Incoming Outgoing | Duration Incoming Outgoing |
| -------------------- -------- -------- | -------------------- -------- -------- |
| less than 1 day 0 0 | less than 1 day 0 3 |
| less than 2 days 0 0 | less than 2 days 0 0 |
| less than 3 days 28 0 | less than 3 days 0 0 |
| less than 4 days 0 0 | less than 4 days 0 0 |
| less than 5 days 0 0 | less than 5 days 0 0 |
| -------------------- -------- -------- | -------------------- -------- -------- |
| </code> | </code> |
| | |
| | In the example data, these are the [[:object:volume|Volumes]] 000003L5, 000004L6 and 000005L6 which are in a move status (one day) out of the subject [[:object:repository|Repository]] but not yet confirmed into their target [[:object:repository|Repository]]. |
| | |
| | {{tag> update_doco}} |
