Service Now ITAM Data Handling Dogan Weber Field

Service Now ITAM Data Handling Dogan Weber

Field Normalization Problem SCCM query returns odd Model Numbers for computer systems

Field Normalization Some workstation records contain unclean data

Field Normalization This leads to unclean records in Service Now

Field Normalization But why is this an issue if we still know that the laptop model is “Elite. Book 2530 p”?

Field Normalization • This is a “Hardware Model” record • It contains all information which are shared through all 2530 p laptops • If we have a specific asset and link it with this table, the asset will be enriched with the model’s data

Field Normalization • Note the exact Hardware Model Name

Field Normalization Back to the recently imported workstations

Field Normalization The System does not know a hardware model “…(GS 550 AV)” …

Field Normalization … so it creates an additional model with empty fields

Field Normalization See the unclean model name from our SCCM import … so it creates an additional model with empty fields

Field Normalization Please note that we lost partly important information compared to the original, clean model record.

Field Normalization This is the point where Field Normalization Helps to solve this problem

Field Normalization With Field Normalization, we can tell the system that the unclean model name is actually a HP Elite. Book 2530 p

Field Normalization It will automatically correct the data

Field Normalization With this pattern we tell the system • If the Hardware Model Name contains the word “ 2530 p” • no matter what comes before or follows after • The system will correct the value

Field Normalization Now we only have to tell the system which exact Hardware Model we mean by 2530 p.

Field Normalization The “Coalesce to” entry defines the correct model

Field Normalization Through Field Normalization these unclean records

Field Normalization Through Field Normalization are transformed to business usable records

Field Normalization Conclusion

Field Normalization enables us to • Keep the data clean • Force the data into a shape we desire • Check entries for correctness • Ensure data connection • Highly increases quality of reports