How do normalize computer name from different data sources?

edited February 28 in Asset Management
I need to compare data from two different data sources. What's the best why to normalize the data. In one source it's uppercase computer name and sometimes has the domain like contra\lt-fun. Can normalization be applied at ingest or does that have to be in each and every query?

I'm trying to avoid having to always add something like this in my query:



This Month's Leaders