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

AllenTschumper
Kilo Contributor

‎10-15-2020 03:49 PM

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?

Labels:
0 Helpfuls
  • 4,974 Views
16 REPLIES 16

Community Alums
Not applicable

‎10-16-2020 12:19 PM

Hi Allen

 

You can do this en-masse without a script (though it may be faster to do it with a script, depending on the number of records). 

If you filter the list on the https://[instance_name].service-now.com/sys_archive_log_list.do to the records you wish to restore, you can select all the tick boxes and then use the UI action "Restore Record and Related Records"

find_real_file.png

You can also increase the system property for the number of records on display at any one time to do more at once - just be conscious that you'll hit the transaction quota time limit if you're doing lots!

Cheers
Mike

Preview file
29 KB

AllenTschumper
Kilo Contributor
In response to Community Alums

‎10-19-2020 10:20 AM

that's awesome!  I knew there was a table or table list somewhere I could do this...just couldn't wrap my head around as to where 🙂  Thank you for rattling the marbles a little bit.

Now, that system property, which exact could I hit to up that amount over 100 at a time?   I understand it could lead to timeouts...but I'd like to increase that to more than 100 at least. 

0 Helpfuls

Community Alums
Not applicable
In response to AllenTschumper

‎10-19-2020 10:25 AM

It's called glide.ui.per_page, and it's a CSV list of options that you want to be visible (note, they'll be visible to everyone - not just you). 

 

find_real_file.png

Preview file
20 KB
0 Helpfuls

AllenTschumper
Kilo Contributor
In response to Community Alums

‎10-19-2020 10:57 AM

Yep, found that before you replied 🙂  Is there a way to bump that over 100?  I tried to bump it to 1000 and the drop down still just shows these 5 values.  I took away 10,15,20 and 50 and had it as 100,1000,5000 just to test and then only the 100 shows up. Is there something somewhere else that limits this to 100?

0 Helpfuls