<style>
.release-box {
	height: 30px; 
	width: 100px; 
	padding-top: 8px;
	text-align: center; 
	border-radius: 5px; 
	font-weight: bold; 
	background-color: #d4af37;  
	border-color: #FCE28A;
}

.release-box:hover {
  	cursor: hand;
    cursor: pointer;
    opacity: .9; 
}
</style>
<meta name="robots" content="noindex">

<div class="release-box">
<a href="https://docs.perspectium.com/display/gold" style="text-decoration: none; color: #FFFFFF; display: block;">
Gold
</a>
</div>



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.

(info) 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.




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.




Next Steps

View and Report Table Compare Results



Similar topics

Contact Perspectium Support

US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com