Versions Compared

Old Version 5

changes.mady.by.user user-1bc08

Saved on

compared with

New Version 6

changes.mady.by.user user-1bc08

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


HTML
<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. 


Anchor
bulk_share
bulk_share

Compare existing records with bulk share

To get started with comparing existing records with bulk share, follow these procedures:


UI Steps


UI Step

Create a bulk share 

Follow the procedures to create a new bulk share here without executing the bulk share. 


UI Step

Enable table compare on the bulk share

Check the Advanced option. Then, under the Advanced tab, check the Enable confirmation option. 


UI Step

Access Audit Shares

After the bulk share has completed, navigate to Perspectium > DataSync > Tools. Click Table Compare: ServiceNow to Database. Then, click Audit Shares.  

Image RemovedImage Added


UI Step

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. 



UI Step

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. 


Anchor
dynamic_share
dynamic_share

Compare deleted records with dynamic share

To get started with comparing deleted records with dynamic share, follow these procedures:


UI Steps


UI Step

Create a dynamic share 

Follow the procedures to create a new dynamic share here.


UI Step

Enable delete action

In the Trigger Conditions tab, check the Delete option. The deleted records will be tracked in the receipts table.  


UI Step

Access Audit Shares

Navigate to Perspectium > DataSync > Tools. Click Table Compare: ServiceNow to Database. Then, click Audit Shares. 


UI Step

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.



UI Step

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

Content by Label
showLabelsfalse
max5
showSpacefalse
cqllabel in ("datasync-for-servicenow","datasync-tools") and space = "gold"

Contact Perspectium Support

US: 1 888 620 8880

UK: 44 208 068 5953

support@perspectium.com