Table Monitoring allows users to set up email notifications when subscribing/publishing throughput is slower than usual and table get backed up. Currently, four tables can be monitored: Inbound Messages, Outbound Messages, Outbound Attachments, and Outbound Audits.

Prerequisites


(warning) First, you will need to install DataSync for ServiceNow, run the Finish Install scripts, and set your initial Perspectium & Replicator properties.

Create filter conditions for a ServiceNow dynamic share or bulk share

To monitor tables in your ServiceNow instance, follow these steps:


Access Table Monitoring

Log into your ServiceNow instance and navigate to Perspectium > Control and Configuration > Table Monitoring. Check the Active box. When tables monitoring is activated, the tables will be queried every three hours by default.  

Select the recipient(s)

Fill in the Recepient(s) field with the recipient's email address. This field will determine who will receive the email notification. Multiple emails can be entered by adding a comma between them. Click the Save button to save your changes.

Select the tables 

Select the tables you want to monitor from the Available list and use the  button to add the tables to the Selected list. Click Update Table Menu to save your changes and make the selected tables appear in the Table Menu

Edit the query and threshold 

The Table Menu is used to edit the query and threshold performed on the table. By default, Table Monitoring will look for records in the ready state.

(info) NOTE: If 50 or more such records exist on the table at the time of the query, a notification is sent by email each time the scheduled job runs. If you want to change the number of records to monitor, go to Perspectium > Control and Configuration > All Scheduled Jobs. Then, search for Perspectium Table Monitoring, and change the value in the script from 50 (default) to the desired number of records. 


FieldDescription
NameRepresents the name of the tables that will be monitored.
QueryString that represents a filter for a list of records. This can handle any encoded query. 
ThresholdAmount of records that meets the query. This can accept numbers greater or equal to one.
EditSaves the entries