Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Normalization Issue - Duplicate entries of normalized records for same vendor on core_company table - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Normalization Issue - Duplicate entries of normalized records for same vendor on core_company table
KB0855759

Normalization Issue - Duplicate entries of normalized records for same vendor on core_company table


2642 Views Last updated : Apr 8, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

After completing guided setup for Normalization Data Service, we noticed core_company table had duplicate entries of normalized records for same vendor.

Release

Any

Cause

Normalization Data Services (NDS) does not normalize the core_company table. So it won't reduce core_company records where there may be duplicate names. It creates a one to many relationship between the normalized company name (cds_client_name) table that matches the name in core_company table record to Normalized mapping (cds_client_mapping) record. Then it updates the reference qualifier on select cmdb and asset related fields that reference core_company table to display the record where the name matches the value in the normalized company (cds_client_name) table.

Resolution

A user can manually add many records to core_company table with same or similar name. So if "Normalized data service client" plugin is enabled and follow Normalized Data service guided setup. Then Normalized data service put the correct core_company value with column "Normalized = true". So the record with column value "Normalized = true" should be picked.


Conclusion - Multiple records can be present in the core_company table with same/similar name. If the record has "Normalized = true", then this is the only record shown when picking up the company value from the asset table. Meaning, it will only let you to select the core_company record which is normalised.


The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.