Page History
HTML |
---|
<style> .release-box { height: 30px; width: 100px; padding-top: 8px; text-align: center; border-radius: 5px; font-weight: bold; background-color: #8efeb3; 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/krypton" style="text-decoration: none; color: #FFFFFF; display: block;"> Krypton </a> </div> |
Anchor | ||||
---|---|---|---|---|
|
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.
Panel | ||||||
---|---|---|---|---|---|---|
| ||||||
|
Info | ||
---|---|---|
| ||
|
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
Anchor Archive 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.
Archive allows you to use the Bulk Share feature to back up tables to a queue that the DataSync Agent can then save into an external database. The Archive option provides a simplified view of the Bulk Share feature so as to allow you to specify which table to archive. Records are sent out in the standard Perspectium message format (as found in the Messages > Outbound table)
The Archive option offers the following choices after navigating Archive Data > Archive:
- Create New Archive - Create a new archive (bulk share) configuration to specify which table you want to archive and to what target queue the records will be shared out to.
- View Archive Configurations - View previously created archive configurations. This view will only list archive configurations and not standard bulk shares.
Restore
Anchor | ||||
---|---|---|---|---|
|
Restore allows you to restore previously executed archives. Restore works by sending a command message to the DataSync Agent which will then query the external database where the records were previously saved to and send those records back into ServiceNow. The records are sent to the subscribed queue the ServiceNow instance consumes from, with records sent in the Perspectium message format (as found in the Messages > Inbound table) so they can be read in using the Perspectium Core application.
The Restore option offers the following choices after navigating Archive Data > Restore:
- Create New Restore - Create a new restore (bulk share) configuration to specify which archive you want to restore from.
- View Restore Configurations - View previously created restore configurations. This view will only list restore configurations and not standard bulk shares.
Info | ||
---|---|---|
| ||
|
Dashboard
Anchor | ||||
---|---|---|---|---|
|
The Dashboard provides a view of the data you've archived using the Archive Data feature.
After navigation to Archive Data > Dashboard, you will see the Dashboard user interface that shows the following:
Recent Archives
Record Breakdown
Total Daily/Monthly Records
Total Daily Records: Displays the total records archived for the current day.
Total Monthly Records: Displays the total records archived for the current month.
Info |
---|
Changing the date/month on the calendar does not affect this count. |
Records Sent / Hour and Records Sent / Day
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 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.
Info 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.