Hardware Models and Import Sets

[ajormsby]

Hi,

I am currently configuring the Asset Management and Configuration modules Service Now Geneva in preparation of the CMDB implementation. I seem to be having difficulties with Hardware Models when importing. Initially, I had imported all of our Hardware Models consisting of Name, Category, Model Number and Manufacturer which was successful, but on importing the CMDB asset records the import had created duplicate Hardware Model records but without Manufacturer.

I have since tried an alternative approach. I cleared all Models, and imported the CMDB allowing the automatic creation of Hardware Models. I then did an import of the Manufacturers, targeting the Hardware Model table which worked fine. The problem I now have is that any further CMDB imports i do, to see how Service Now responds to import sets for updates is that the Hardware Models are again duplicated.

It seems to me that the issue is the Manufacturer assigned to the Hardware Model because of how the Display Name is auto populated. All Manufacturers are currently located in "Companies".

Am I missing something here? My objective is to have Hardware Models containing both Manufacturer and Model Name/Number, without duplications being created when importing.

[jake_mckenna · Accepted solution]

It sounds like you are building the model records correctly, but from you CI import you may want to update the transform map to indicate a reference field to match on. In most cases you will try to match on the model name that links to the model you are looking for. Transform maps match reference fields based on the display value so when it comes to models you are going to get the display value. Although in my experience the actual data is linking to just the model name. Updating the transform field mapping for model_id might help in this process to instead look for a matching model name or model number.