Audit Shares allows you to compare records from ServiceNow with a database by comparing the records shared out per share. This way you can ensure that the bulk shares, along with deletes shared by dynamic shares, were captured in the database properly.
There are two options available:
Compare existing records with bulk share
Compare deleted records with dynamic share
You can choose to run or schedule a table compare for existing records with a bulk share and/or dynamic share for deleted records.
Compare existing records with bulk share
To get started with comparing existing records with bulk share, follow these procedures:
Create a bulk share
Follow the procedures to create a new bulk share here without executing the bulk share.
Enable table compare on the bulk share
Check the Advanced option. Then, under the Advanced tab, check the Enable confirmation option.
Access Audit Shares
After the bulk share has completed, navigate to Perspectium > DataSync > Tools. Click Table Compare: ServiceNow to Database. Then, click Audit Shares.
Select the bulk share
By default, all bulk shares will be selected. Otherwise, select the bulk shares you want to use in the table compare. You can select all the bulk shares with Select All and deselect all the was selected with Deselect All.
NOTE: You will need to select bulk shares that have been executed already to start table compare.
Run table compare
Click Run Table Compare to start executing the table compare. Or, click Schedule Table Compare to have the table compare configuration run on a scheduled basis.
Next Steps
View and Report Table Compare Results
Or continue to the steps below to compare deleted records with dynamic share.
Compare deleted records with dynamic share
To get started with comparing deleted records with dynamic share, follow these procedures:
Create a dynamic share
Follow the procedures to create a new dynamic share here.
Enable delete action
In the Trigger Conditions tab, check the Delete option. The deleted records will be tracked in the receipts table.
Access Audit Shares
Navigate to Perspectium > DataSync > Tools. Click Table Compare: ServiceNow to Database. Then, click Audit Shares.
Select the dynamic share
By default, all dynamic shares will be selected. Otherwise, select the dynamic shares you want to use in the table compare. You can select all the dynamic shares with Select All and deselect all the was selected with Deselect All.
Run table compare
Click Run Table Compare to start executing the table compare. Or, click Schedule Table Compare to have the table compare configuration run on a scheduled basis.