Hello
We have a integration with Intune which imports all our assets. Originally the model field in Intune went to the model display name field in ServiceNow through a transform map. However the display name was not always consistent especially between manufacturers and so it was mucking up all our reporting.
For example:
The laptop model displays as 'Latitude 7300' on Intune, sothis is how it pulls through into the asset. However we want it to have it's full name including Dell, so it matches the HP laptops which report through as the full 'HP EliteBook 640' model name.
This is the same for tablets which display as SM-T500 in Intune, but we want the model display name to be Samsung Galaxy Tab A7 when it syncs through to ServiceNow.
So as a workaround we created a new field called 'Intune model' in the asset table which is now where the transform map points. We then have to manually update the 'Display Name' field in ServiceNow based on the Intune Model.
I want to know how I can automate this so if the Intune Model gets populated as 'SM-T500', it automatically populates the Display name/model/model number as per the products model table. I know I can probably do this as a onclient script, but with the amount of different models and variables of each (e.g SM-T500 vs SMT500), the script will be so big and very hard to maintain.
I was hoping there was a way to create a table where column A would have all the different Model names from Intune, then Column B would have the product model in Snow it should relate to and then lookup this up during the Intune import and autopopulate.
| Intune Model | ServiceNow Product model |
| SM-T500 | Samsung Galaxy Tab A7 10.4 |
| SMT500 | Samsung Galaxy Tab A7 10.4 |
| Galaxy Tab A7 | Samsung Galaxy Tab A7 10.4 |
| Tab A7 | Samsung Galaxy Tab A7 10.4 |
I am open to ideas if there is a better way to do it.... I just need a way for it to be consistent across all models to report consistently.
