We need to be able to mass restore archived records...is that possible? If so, how?

[AllenTschumper]

We are moving, or already have moved to a CSM instance of service now and are soon to retire our old instance (end of year),

Now we need to move old data over from the old instance.  I want to move our archived data.  I am finding that I need to restore the RITM data to be able to retain the variables on them.  If I don't restore, things do not work as needed.  

But really, I just want to know if there is a way to mass restore archived records and NOT have to do them one-by-one.  Which the latter is no feasible with having hundreds of thousands of records.  I am assuming we'd need a script.  

Anyone able to do this?

[Community Alums]

No there shouldn't be anything else, all I did was Ctrl+F5 to refresh and it came up - didn't need to clear the system cache (though you could try that, by going to https://[instance].service-now.com/cache.do) 

I just added ,10000 to the list and it worked. 

[AllenTschumper]

interesting, I figured it would do that same for me when I did it 🙂  Now that I've seen you do it in practice, I'll give'r a shot...will let you know.  

[AllenTschumper]

okay, was getting the right click drop down.  I switched to the old UI15 and boom, did the same thing and now I see the Show > 10000 Rows.  Switch back to UI16 and while it's in the property, it's still not in the drop down.  

[Community Alums]

Interesting. 

I'm really not sure why that is - can't think of anything, sorry!

If you want to, you can force it through a parameter in the URL https://[instance_name].service-now.com/sys_archive_log_list.do?sysparm_force_row_count=10000

[AllenTschumper]

Tried that, ran through that URL and it came up, but only with the 100.  Hmmm.  Not sure either.  Seems pretty straight forward.  Not sure what the heck it's doing 🙂