Location - Country, State, City Normalization

[Community Alums]

Hi CSDM community, 

We have location table data coming from various sources. this data is inconsistent and unnormalized. For an example : Peoplesoft has UK named as "UK" while from active Directory we get UK as "United Kingdom".

Does ServiceNow currently have any product our OOB functionality to normalize country, state and city name ? 

Have any of you had similar requirement , If yes, how to achieve this ?

What are the best practice to keep country , state and city data clean and normalized ?

[Patrick Laroch1]

Have you tried this

[Barry Kant]

Hi all,

also check this to prevent this in the future:
Utah - IRE support for non-cmdb tables

Specifically handy when you have multiple data sources for other master data tables.

BR,

Barry

[mikkojuola]

Hi Rajneesh,

The IRE "expansion" in Utah to all tables definitely helps here, as Barry already pointed out.

In case you need further data quality checks related to location data and location hierarchies, you can use DCM to define a model and run audits against it. It cannot figure out that "UK" and "United Kingdom" should be the same, but it can check if certain types of locations have correct references to other locations with the correct types.

Here's an example of a "blueprint" created with DCM:

With this blueprint, you can run an audit and compare your current data against the required data model.  You can start a free trial from the Store to try this out, and I'm happy to help if you have any questions.

Best regards,

--Mikko