Versions Compared

Key

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

Choosing Legacy Table Compare: ServiceNow to Database as your option to compare records makes a call to the Perspectium Integration Mesh to retrieve your agent stats. These stats will then be saved to the PSP Table Stats (u_psp_table_stats) table in your instance so you can see your database name, ServiceNow and database record counts, differences between the counts, and more. 


UI Text Box
typetip

It is highly recommended to use Audit Shares or Compare Records by Table/Condition instead of our the legacy way of table compare. 



Procedures 

To see the difference between the database tables and ServiceNow record, follow these steps: 



UI Steps


UI Step

Access Legacy Table Compare 

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


UI Step

Update Stats 

Click Update StatsThe DataSync application will reach out to the Perspectium Integration Mesh according to the endpoint in Perspectium properties.

The PSP Table Stats will populate like the following: 

To see more information such as the database name and agent name, click into the records listed.