Update bulk records in Servicenow

[Aradhana]

Hi,

I have a requirement to update 1.6 lakh knowledge records in a ServiceNow instance. The task involves searching for specific keywords (e.g., 'abc') in two fields, 'article body' and 'short description,' and replacing them with 'xyz'. This process may need to be scaled up in the future. While this can be done within ServiceNow, it could result in transaction issues. What approach should I take to accomplish this task, and how can I mitigate potential transaction issues? What are the possible solutions?

[Mark Manders]

One way to do this and have some control over it, is to create a list of all your non retired articles (the keywords can also be in draft/review articles) and put only the short description and article body columns on it. Add the filter of 'short description' or 'article body' contains the keywords.
Use the 'easy import' functionality to export this list for update (which will include the sys_id's) and do the 'find and replace' in excel. With a huge amount of articles, it can be recommended to do it in batches. After the replacing is done, you can use the same functionality to upload the changes. 

I hope you won't replace too much.