Share display values for reference fields and choice lists

Display values are resolved display values of referenced records in the current record being shared. By default, ServiceNow display values for reference fields and choice lists will not be shared out in your dynamic shares and bulk shares. You can change this setting in order to enable the sharing of display values for these fields.

This feature is useful if you're sharing tables that do not need to include referenced records. The display value may contain enough readable information for your report.

Here's how to change the setting:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. To enable this feature, turn on the toggle under Enable DataSync to add display value fields for reference and choice fields (prefixed with 'dv_' by default)
   
   
3. Scroll to the bottom and click Save.
   
   

↑ Go to top of page

Use a percentage of workers to run concurrent scheduled bulk shares

In some cases, you may find that scheduled bulk shares are impacting the performance of your ServiceNow instance, as they use too many of the instance's available scheduled jobs (workers). If this happens, a good troubleshooting practice is to specify a percentage of the workers on your ServiceNow instance's nodes that will run scheduled bulk shares concurrently. Here's how:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. Use the dropdown labeled Percentage of workers used to run concurrent Scheduled Bulk Shares to select your desired percentage. 
   
   
3. Click Save. 

↑ Go to top of page

Save Perspectium properties in the sys_properties table

This feature lets you improve the overall performance of your Perspectium integration by saving all properties related to your Perspectium integration to ServiceNow's System Property (sys_properties) table. By default, this option is disabled, and your Perspectium-related properties are saved in the Perspectium Properties table (u_psp_properties). If you enable this option and then make changes to your Perspectium properties, you can then copy those properties to the Perspectium Properties table by disabling this option again.

Here's how:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. To enable this feature, turn on the toggle under Save Perspectium properties in the sys_properties table.
   
   
3. Click Save. It may take 2-3 minutes for this change to be applied to your instance, as the system saved all Perspectium properties over to the sys_properties and rebuilds the system cache.
   
   

↑ Go to top of page

Disable inbound messages

By default, DataSync for ServiceNow allows your ServiceNow instance to receive inbound messages. However, if your ServiceNow instance is to be used for sharing purposes only (and not for subscribing purposes, or the receipt of incoming messages from other apps or data sources), you have the option to disable inbound message functionality. Here's how:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. To enable this feature, turn on the toggle under Disable inbound messages.
   
   
3. Click Save. 

↑ Go to top of page

Enable multiple jobs to process messages in the inbound table

By default, the Perspectium DataSync Subscriber scheduled job in ServiceNow pulls and processes the messages from your Mesh server's inbound queues. However, you can also have the job pull messages into the ServiceNow inbound table (psp_in_message) in a Ready state so that Perspectium Inbound Processor scheduled jobs process the inbound table. This allows you to prioritize the processing of your inbound messages by configuring the Perspectium Inbound Processor jobs to apply various filters. 

Here's how to enable this feature:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. To enable this feature, turn on the toggle under Allow DataSync inbound messages to go to a state of ready isntead of being consumed immediately...
   
   
3. Click Save. 
   
4. Now, go to Perspectium > Control and Configuration > All Scheduled Jobs.
   
   
5. In the Schedule Jobs table, find and select the Perspectium Inbound Processor job. 
   
   

6. Within the script for this job, find the addCustomQuery function on line 50 and modify the script by adding your customer queries.
   
   To do this, choose one of the following options:
   
   Add customer queries by key:
   
   

   function addCustomQuery(igr) {
       igr.addQuery("key", "=", "dev12345");
   }

   
   OR
   
   Add customer queries by name:
   
   

   function addCustomQuery(igr) {
       igr.addQuery("name", "CONTAINS", "incident");
   }

7. Click Update (top right)
   
   
8. Create a copy of the modified job so you can apply other filters to enable simultaneous processing.

↑ Go to top of page

Skip updating the sys_domain_path field when subscribing to records

This feature allows you to skip updating the sys_domain_path field on a record to keep the value as it currently is, or allow the system to update the record appropriately if the domain changes. In domain-separated ServiceNow instances (Helsinki version or later), if you update a record without changing the sys_domain field, the sys_domain_path will be updated to the default global value of “/” that comes in with the incoming record. Prior to the ServiceNow Helsinki release, the system would instead auto adjust to the proper domain path after updating the record.

Here's how to enable this feature:

1. First, you must request domain separation for your subscribing (Helsinki version or later) ServiceNow instance.
   
   
2. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
3. To enable this feature, turn on the toggle under skip updating the sys_domain_path field when subscribing to records.
   
   
4. Click Save. 

↑ Go to top of page

Alert before bulk sharing a large number of records

This feature will enable an alert to pop up within your instance whenever a ServiceNow bulk share that you're trying to execute exceeds a minimum number of records. By default, the minimum number of records to trigger an alert is 1,000,000. Here's how to turn on that alert:

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. To enable this feature, turn on the toggle under Alert me before bulk sharing a large number of records.
   
   
3. Enter the desired minimum number of records in the field labeled Minimum number of records to trigger an alert before bulk sharing.
   
   
4. Click Save. 

↑ Go to top of page

Generate unique names for business rules associated with dynamic shares

This feature allows you to allow newly created business rules to have a unique name. By default, the business rule created is named Perspectium Replicate.

1. In your sharing ServiceNow instance, go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. To enable this feature, turn on the toggle under Generate unique names for the business rules associated with dynamic shares.
   
   
3. Click Save. 
   

↑ Go to top of page

Set receipt tracking

Perspectium's receipt (u_psp_receipt) table as used for Data Guarantee in ServiceNow is rotated to preserve your instance performance. See ServiceNow Table Rotation for more information. 

To configure how often the receipt table is rotated, follow these steps: 

1. Go to Perspectium > Control and Configuration > Properties > DataSync Settings.
   
   
2. Scroll to the input labeled The number of days to keep message receipts before being deleted...  
   NOTE: This applies to messages in any state (success, pending, error). The number of days must be less than 100.
   
   
3. Enter the number days you want to keep the records in the receipt table. 
   
   
4. Below the property is The number of rotations of deleted data to keep before being overwritten...
   NOTE: If you enter 10, there will be 10 rotations of deleted data before the first instance is overwritten. The number must be less than 100.
   
   
5. Enter the number of rotations.  
   
   
6. Click Save.

↑ Go to top of page