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]

Are you sure this will work? The chance of the combination 'abc' being used in a different context than just that keyword is very high. 

First check on the number of published articles it is concerning and then decide if it wouldn't be better if you update them to something more neutral, so you don't have to do this over and over again.

[Aradhana]

Thanks for the response Mark!
The keyword 'abc & 'xyz' is just an example, it might be specific to certain Line of business/domain. 

[Mark Manders]

That still leaves the same issue: are the line of business or the domain so specific that it can't be used in any other way than the meaning you are replacing? You are talking about a huge number of articles and a mass update could end up in making a lot of articles useless. 

[Aradhana]

Completely agree Mark. But I have been given a requirement to search and replace all mentions of old LOB names with new LOB names following the ORG changes (as a SPIKE). This will be limited to short descriptions and article body as of now (Restricting the replacing of LINKS contained in an article body).