Archiving Related records

iyyappan_3
Giga Contributor

Hi,

I am just trying to archive incident records with related Affected CI's.

I created a Archive rule, which works expected and archives incidents as per my condition.

I have added new Archive related record rule and selected Reference as Affected CI's and the Reference table is task_ci and reference field is task(which got populated automatically when I select reference. I don't find any other reference for Affected CI.

But my next archive iteration did not archive my related records, when I check the related record the reference field Task has become blank.

Am I missing anything here?

How can I verify if related records are archiving?

Thanks!

Regards,

Iyyappan

6 REPLIES 6

Hi Sandhya,



I replied to you on your post:



Data archiving for incident is throwing error



Regards,


Sergiu


garrett_prochno
Kilo Contributor

One of the problems with the built-in archiving is that it simply moves the data into another table. Typically, since you're already querying on indexed fields (e.g. active=true) this might not really do much for you. All of the related data records are also still in the system. Over years, this can really start to add up and introduce serious performance problems on your instance (even in the largest ServiceNow architecture sizings).



Using Perspectium's Replicator we can truly archive all of the data out of ServiceNow and clean up the source tables. Because we're a native ServiceNow app, pushing the data into another ServiceNow instance, database, or endpoint is all easily done with a simple interface where data relationships are intrinsically understood.



--Garrett Prochnow


www.perspectium.com