Table Monitoring allows you to set up email notifications when subscribing/publishing throughput is slower than usual and tables get backed up.
Currently, four tables can be monitored: Inbound Messages, Outbound Messages, Outbound Attachments, and Outbound Audits.
Here's how to set it up:
- In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Troubleshooting.
- Click Table Monitoring.
- Check the Active box. This enables the tables to be queried every three hours by default.
- 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.
- Click Save.
- In the Table Names section, 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.
- When you've selected all desired table, click Update Table Menu. You'll see the newly selected tables appear in the Table Menu section.
- In the Table Menu section, fill in the query and threshold for your table monitoring. By default, Table Monitoring will look for records in the ready state.
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.
Field | Description |
|---|---|
| Threshold | Amount of records that meets the query. This can accept numbers greater or equal to one. |
| Name | Represents the name of the tables that will be monitored. |
| Edit | Saves the entries |
| Query | String that represents a filter for a list of records. This can handle any encoded query. |