Data Viewer

User Manual, Admin Guide, Rest API, Performance API, SnowMirror Monitor, ServiceNow Upgrade, Error Codes, Release Notes

1. Introduction

Data Viewer is a tool for viewing data that has been replicated into your system. It allows users to view, filter, and search for records in this data. The tool provides a simple way to work with data replicated through SnowMirror, without the need for complex setup or integration with other systems.

2. Overview

Data Viewer consists of two main tabs. Tables tab is used to work with data replicated to the database, while Attachments tab displays data stored in the file system.

2.1. Tables

This tab contains data stored in the database. Available workflows are Replication and Archive.

2.1.1. List

The list contains a preview of basic information of each available replication.

List
Workflow	An icon representing the type of replication. The type can be either replication or archive.
Name	The name of the replication, chosen by the user. It does not have to match the mirror database table name or the table name in ServiceNow.
Last Successful Run	The date and time when the replication last ended successfully.
Newest Entry	The date and time of the most recent entry, based on the newest `sys_created_on` value stored in the database table.
Total Count	The total number of rows in the database table.
Table Size	The amount of space occupied by the database table.
Display Values	Indicates whether the database table contains display values.
Attachments	Indicates whether SnowMirror has replicated related attachments for the given table.

2.1.2. Data

Lists all data stored in the selected database table. Display values are preferred if present.
The columns in the summary table are obtained from ServiceNow sys_ui_list table. Global Default View is used.
You can quickly navigate between replicated database tables using choice box in the upper right corner.

2.1.3. Detail

Shows the detail form of the stored entry from database. Display values are preferred if present.
You can choose between the Default View obtained from ServiceNow sys_ui_section table or show all replicated columns using choice box in the upper right corner.

If SnowMirror contains attachments related to the selected entry, they will be listed at the top of the detail form.
If the field with reference type can find replicated table with related entry present, it is linked together and button is displayed.
If sys_journal_field table with all columns is replicated and contains related data, additional comments and work notes are displayed.

If multiple replications are created for same related table, the correct replication is selected using this algorithm.

2.2. Attachments

This tab contains data stored in the file system. Available workflows are synchronization and archive.

2.2.1. List

The list contains a preview of basic information of each available replication.

List
Workflow	An icon representing the type of replication. The type can be either synchronization or archive.
Name	The name of the replication, chosen by the user. It does not have to match the mirror database table name or the table name in ServiceNow.
Last Successful Run	The date and time when the replication last ended successfully.
Newest Entry	The date and time of the most recent entry, based on the newest `sys_created_on` value stored in the metadata database table.
Total Count	The total number of rows in the metadata database table.
Folder Size	The amount of space occupied by the folder.
Table	Indicates whether SnowMirror has replicated related table for the given attachments.

2.2.2. Data

Lists all stored attachments in the selected folder.
You can quickly navigate between replicated attachments using choice box in the upper right corner.

If related table is present, you can navigate to it by click on object name.