Archiving incident records

[johnrob18]

I have a few questions with regard archiving

I am unsure from the documentation what the archived record will look like in relation to the original record, is there any relationship in the names? is it a one to one relationship or does one archived record cover a date range?

How is the naming convention and how easy is it to (say) restore all incidents between January and March 2015 if we were required by audit?

Can I export migrated data to another environment by exporting the and importing the files? Are there any known issues around this?

[Dubz]

Hi John,

It's my understanding that the individual record will still exist but the data is flattened out so there aren't base tables and extended tables etc. Any referenced data will be stored on the archived record as a simple string.

I think the best way forward would be to test the application on your pre-prod or developer instance to see what the resulting data looks like.

[johnrob18]

Having archived the records, can I then export/import them to a different environment? Is this quicker than normal/export/import?

I have over 367601 incident records to move

[Dubz]

Are you moving them to another instance of Service Now? If so then i would advise against archiving first. All referenced info will be saved, i assume, as sys_id's so they won't match up on the new environment. You can archive related records as well but there may be some records you want to retain and some you want to move so the whole thing could get messy.

You can increase the export limit when exporting from a table a per the link below so you could increase your limit to 100k rows and then run your export in 4 batches

Export limits

[johnrob18]

D,

yes we are creating an OOB Jakarta environment - stripping all processes back to OOB and importing existing records - I have spent ages export/importing records but now find I am 1000's out (must have missed some some where) - trying to think of a way to reconcile or - start again.

In reality only 12 months of data is needed for trend analysis but 7 years is needed for audit. So an archive of 6 years data would save me no end of rework or a lot of comparisons and reconciliation