Is there a way to perform a mass update to CMDB locations lets say 13,000 records?

Chris216 · ‎01-24-2019

I am requesting guidance on how to perform a mass update to CMDB CI's within the ServiceNow environment. As it is right now i am able to update one record at a time but that is not feasible with nearly 13,000 records that require an update.

Thank you,

Chris

Henrik Jutterst · ‎01-28-2019

Hi Chris,

Here's how to do a mass update simple way. It's also an out-of-the-box function.

In a list view (for example cmdb_ci_server), filter out what items you want to update
Right click on the column header and select "Update All"
You can now add the value to the form field that you want to update (one or more)

Done

View solution in original post

Tony Chatfield1 · ‎01-24-2019

Hi, exactly which method you use to update data will depend on the type of changes you are making?

You have a number of options for updating data.
You can extract and then import updated table data via xls
Modify data directly via script
Or potentially export xml, tweak it and then import it back.
Depending on your configuration you may also be able to update multiple records from the list view manually.

The best option will depend on your environment and the changes you are making.

Henrik Jutterst · ‎01-28-2019

I would suggest using ServiceNow OOTB function "Update All" to do mass update. See my post below. If you haven't tried it, it's really simple and effective to use.

rahulpandey · ‎01-24-2019

Hi Chris, You can break it using chooseWindow into smaller chunks an put into loop. Refer below https://developer.servicenow.com/app.do#!/api_doc?v=kingston&id=r_ScopedGlideRecordChooseWindow_Number_Number_Boolean

Henrik Jutterst · ‎01-28-2019

Use the built in function "Update All" instead. Much easier to do your mass updates. 🙂