Archive Data (found under DataSync) allows you to leverage the Perspectium DataSync solution to archive data from your ServiceNow instance to an external database. Whereas ServiceNow's built-in data archiving feature limits you to running archiving each table record only once, the Archive Data feature allows you to archive a record multiple times and to an external database of your choice using the Bulk Share fuction.
Explore the various contexts and instructions for using this feature.
NOTES:
Archive Data is a separate update set installed on top of the Perspectium Core application. Contact Perspectium Support to obtain this update set and for more information.
- This feature requires Krypton 8.2.0+ of the Perspectium Core application for ServiceNow and Krypton 8.
Minimum Requirements and Support
| Perspectium Core (ServiceNow app) | Krypton 8.2.0 and newer |
| DataSync Agent | Krypton 8.0.2 and newer |
| Supported Databases | Oracle Microsoft SQL Server |
Once you navigate to DataSync > Archive Data, you will have the following options:
- Archive - Choose the tables and conditions you want to archive from your ServiceNow instance.
- Restore - Choose the previously executed archives you want to restore back into your instance.
- Dashboard - View and monitor the archived data you've executed on your instance.
Archive
There are two options when it comes to comparing tables between two instances of ServiceNow:
- Audit Shares looks at the records that have been bulk shared and compare them to the records in another instance. This is useful for ensuring that bulk shares are captured in the subscribing instance properly.
- Compare Records by Table looks at records that satisfy specified conditions and compares them with the same records in another instance. This is useful if you have multiple dynamic/bulk shares on the same table and want to verify that the cumulative sharing of records is captured properly in the database.
Dashboard
After running a ServiceNow to Database table compare, you can view your results, including the total records compared, records not found in the target database that were shared by the ServiceNow instance or the records not deleted in the target database that were shared out as deleted. A quick summary of previous table compares that have run will also be available with the table provided in the Previous Table Compare Executions section.
Additionally, you can run a report with your table compare results.
Here's how to view your results:
- Go to Perspectium > Perspectium Core > Tools. Click Table Compare: ServiceNow to Database.
- Then, click the table compare that you want to view (either Audit Shares, Compare Records by Table, or Synchronize Deleted Records).
- Scroll to the Previous Table Compare Executions table. This table will provide you with a quick summary of previous table compares that have run. Click the timestamp in one of the entries to view more information about that specific table compare execution such as the bulk shares or dynamic shares involved, the table and conditions use, the time frame, and the individual discrepancies in the target database.
When looking at the results, numbers (such as the Records Reshared to Target to indicate discrepancies between ServiceNow and the database that had to be reshared) will have a background color to indicate as follows:
Number Background Color Description Green No (0) discrepancy between ServiceNow and the database Yellow 10% or less discrepancy between ServiceNow and the database Red More than 10% discrepancy between ServiceNow and the database A Status of Reshared and a Target Discrepancy Type of Not Found indicates the record was not found in the target database and has been reshared. Once the Agent has processed both the reshared message and the compare message to validate the record is in the database, this will update in here to Synced in Database. Note, for each time a record is not found and reshared (even if the same record has to be reshared multiple times because it can't process successfully), a new row will be created in the results with a Status of Reshared and a Target Discrepancy Type of Not Found.
If using Conditional Shares, the Total Records Compared will be the total of records shared to all conditional shares. For example, if your bulk share has 2 conditional shares and one conditional share shares out 173 records and the other shares out 27 records, the Total Records Compared will show 200 records compared.
- (Optional!) If you want to export the results as a .csv or .pdf file, click the available buttons at the bottom of the table. Want to run your own reporting? You can do so by going to the Table Compares (u_psp_table_compares) table. Then, click into the record you want to view.
- In Krypton 8.2.0, the table the compare results are for along with the ability to delete the table compare results record (deleting it from the u_psp_table_compares table) was added. Note the table etnry will show as blank if it's not able to find the table the table compare was configured against, such as when the bulk share related to it is deleted.