Normalization Service Guided Setup - update reference qualifier

[debasish_hm]

In normalization services guided set up there is a step which update the company field reference across the system. However it skips any customized references and  out-of-the-box reference qualifiers which are not empty. In my instance there are more than 1500 such out of the box, reference qualifiers which are not being updated during the guided setup. Do I have to update each of them manually? Has anyone had to do this before?

These seems to be not so insignificant update to go thru each of them and having to update the reference qualified. Kind of defeats the purpose of Guided set up.

[c_d_mitchell]

debasish_hm, did you ever get an answer to this?   I'm at this exact same point.

I did come upon this article https://hi.service-now.com/kb_view.do?sysparm_article=KB0752238 , which makes me feel like this is normal.   

But agreed, going through 1000-2000 records is tedious.   

[debasish_hm]

Hello, yes I landed at that article too. upon further research what I found out was that a lot of those tables which were showing as needing manual updates were extended from the 'cmdb' and 'task' forms. Once I update the reference qualifier of the company field on the cmdb and task task all tables extended from these 2 tables didn't need any manual updates.I still had to update a few more manually form example the company field on the cmn_department table, sys_user table, etc.

Sorry about the delayed response

[Kelly Logan]

How did you find which entries still needed to be updated? If I run the update again I still see the same entries even if I have added (or the child entry has inherited) the 'Normalized' = "True" condition.

[Carl Fransen1]

Hi @Kelly Logan - have you seen this article, it explains things in a lot more detail:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0784201&_ga=2.43366181.187213...