Table Monitoring

Table Monitoring allows you to set up email notifications when subscribing/publishing throughput is slower than usual and tables get backed up.

As for release before 6.1.0, four tables can be monitored: Inbound Messages, Outbound Messages, Outbound Attachments, and Outbound Audits. 

Prerequisites:

 You must enable email sending on ServiceNow. Go to System properties > Email Properties. Under Email sending enabled, check Yes. This allows ServiceNow to send out emails when the Table Monitoring scheduled job runs.

Instructions:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Troubleshooting.
   
   
2. Click Table Monitoring.
   
   

3. Select the tables that you want to monitor from the Available list and use the right arrow button to add them to the Selected list.

   NOTE: Due to performance impact, you can only select up to 50 tables.  

   
   
   

4. When you've selected all desired tables, click Update Table Menu. You'll see the newly selected tables appear in the Table Monitoring Menu chart.
   
   

5. In the Table Monitoring Menu chart, fill in the query and threshold for your table monitoring. By default, Table Monitoring will look for records in the ready state. 
   
   

   Field	Description
   Name	Represents the name of the tables that will be monitored.
   Threshold	Amount of records that meets the query. This can accept numbers greater or equal to one.  NOTE: If the threshold amount is reached, a notification is sent by email each time the scheduled job runs.
   Query	String that represents a filter for a list of records. This can handle any encoded query.

6. Enter the recipient(s) email address in the Recipient(s) field. This is who will receive the email notifications. Enter multiple emails by adding a comma between.
   
   

7. Click Save.
   
   

8. If Table Monitoring is disabled, activate it by clicking Activate Table Monitoring. You can disable it again by clicking Deactivate Table Monitoring.