Prerequisites
First, you will need to install DataSync for ServiceNow and run the Perspectium Finish Install scripts.
Procedure
To import missing records locally, follow these steps:
Import all missing records
Import records missing locally
If you prefer to have all records missing locally records imported into the table without reviewing the XML of each missing record, click Import records missing locally under the Related Links.
This will then schedule a job to run in the background to go through all records missing locally in the PSP Row Discrepancy table at the bottom and import each record's XML from the target instance into the local instance. The Import Records Status field will show the status from when the job is scheduled (after clicking the option to start it) to when it is running in the background to completed when it has finished processing all records missing locally. Like the Compare Rows feature, since there can be many records to process, this may take some time and you will need to reload this form in order to see changes.
Import individual missing record
Access the row discrepancy
In the table compare record, go to the related table, PSP Row Discrepancy, towards the bottom of the form. Then, click the Record Sys ID that has a Missing locally state.
Get Record XML from Target
Click Create Record from Target under the Related Links. This will import the record's XML from the target instance into the Record XML field, allowing you to view the XML to verify this is a valid record you want to import into the instance.
NOTE: Once this option has been clicked and the XML has been imported into the Record XML field, the Get Record XML from Target option will then change to be Create Record from XML.
Create Record from XML
Click Create Record from XML under theRelated Links. This will then create the record in the table being compared by importing the XML from the Record XML field into the instance. The Disposition field will update with the appropriate status as to whether the record was successfully imported or if there was an error along with an error message if available.