How to change Normalized=True to Normalized=False on a company record?

IJMoo · ‎02-10-2024

have reached my understanding of how this part of ServiceNow works…

In the company table I have Dell.Inc and Dell Inc. as a company records.

If I create a new computer record, I can select both Dell.Inc and Dell Inc. as the manufacturer. The reference qualifier that controls the Manufacturer when I create that new CI points at the company table and uses the canonical (normalized) flag as it’s filter criteria as was set in the guided setup for Data Normalization Services.

In theory, because we subscribe the data normalization service I believed that on the Dell.Inc company record the canonical flag should be set to false, but it is set to True, making it a valid company to select as manufacturer based on the reference qualifier that restricts me to only select a Normalized company name as the manufacturer.

The KB article referenced here I believe explains why that happens.. yet In our instance glide.cmdb.canonical.normalize.existing.canonical.core_company_records is already set to True, so what exactly causes Dell.Inc to have canonical flag / Normalized set to true? when it should be false and why can't I change it anywhere?

My aim is to set it to False, so that the reference qualifier that restricts me to only selecting Normalized company records.. in this case Dell Inc. not Dell.Inc actually works.

I just don’t know what I am missing?

AJ-TechTrek · ‎02-15-2024

Hi @IJMoo ,

Refer the below articles, which may help you.

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0859819#:~:text=Normalization....

https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/normalizatio...

https://docs.servicenow.com/bundle/washingtondc-it-asset-management/page/product/hardware-asset-mana...

Please appreciate the efforts of community contributors by marking appropriate response as Mark my Answer Helpful or Accept Solution this may help other community users to follow correct solution in future.

Thanks

AJ

Linkedin Profile:- https://www.linkedin.com/in/ajay-kumar-66a91385/

IJMoo · ‎02-18-2024

Thanks for the response AJ. I read through all those links, but none of them actually tell me how to change the 'Normalized' flag (canonical=true / canonical=false) on a company record from True to False or vice-versa.

In the screenshot example attached, I want to change all company records to have the 'Normalized' value set to false, except for 'Hewlett Packard Enterprise' which I want to be set to 'True'

How do I do that?

Edited to add:

The solution provided in KB0957144 doesn't seem to be working: glide.cmdb.canonical.normalize.existing.canonical.core_company_records as per KB0957144 states:

“The property “glide.cmdb.canonical.normalize.existing.canonical.core_company_records” was added to the system via “PRB1374599" to make the CanonicalUpdater, process the canonical names when core_company is added before the mapping and to control the normalization of existing core company records.

This property allows you to ensure that there’s only one core_company record that is set to Normalized (“canonical”) = true.

More specifically, this addresses the case when there are two or more records in core_company table that were marked as canonical = true prior to running the normalization job."

NarsimhaMurty1 · ‎12-19-2024

Is there any scheduled job which we have run after adding variant