Normalizing Company name on user table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-29-2025 12:51 PM
How can we normalize the company name in the user table?
Our identity management software feeding SN also feeds other applications which use variations on company name to categorize users. This means we have users with "ABC" and "ABC-Student" as a company and we want to normalize to "ABC" for everyone at "ABC".
- We use the normalization services with our CMDB discovery and SAM, but it is not working on the companies in the user table.
- We added the company names to the Normalized Company Names table and the Normalized Mapping table.
- The Normalized Properties are all set to true.
What are we missing?
Any guidance is much appreciated and thank you in advance.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-30-2025 12:00 AM
Did you check out this: https://www.servicenow.com/docs/bundle/yokohama-servicenow-platform/page/product/configuration-manag...
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2025 03:00 PM
Has anything been added to the user table to do the Company normalizing?
If not, you can add this yourself. If you look at the Business Rule "Make Canonical Company" on core_company, you can replicate the bits you need to do the same on the user table.
If you don't need to create any new Company records there is also function "SNC.CanonicalName.normalizeCompany" as listed in Business Rule "Canonicalize Manufacturer Company CI", although I could only get it to work when the boolean parameter was true and then it would return the normalized name.
