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

[Chris216]

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 · Accepted solution]

Hi Chris,

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

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

Done

 

[Chris216]

Thank you Henrick and all on this thread for your valuable feedback. 

Best Regards,

Chris 

[Henrik Jutterst]

Thanks Chris! Glad to help out.

As you might have figured out, this mass update can run on any table - not just cmdb tables. So it might com in handy to you more then just now 🙂

Take care.