Asset Import Utility

[Everton1878]

I've been doing some more testing with the Asset Import Utility and it now seems to be duplicating entries rather than updating the ones that already exist

It wasn't doing this when I first started testing it a few weeks ago, I've now got 3 entries per machine

Has anything changed in Service Manager recently that may have caused this?

I would have thought that it would look at the machine name as being a primary key and not allow duplicates

cheers,

Pete

[Guest]

Hi Pete,

Nothing should have changed relating to this recently. This is usually down to a configuration issue in the conf.json file. 

The unique identifier (from the DB) needs to be written in the h_name column of both the AssetGenericFieldMapping and AssetTypeFieldMapping objects. Otherwise the tool can’t work out if there are duplicates or not. 

So as a very basic example (taking some extracts from the conf.json file:

......
"AssetID": "ComputerName"
"Query": "SELECT [ComputerName], [Manufacturer] from DatabasesAssets
......
"AssetGenericFieldMapping":{
"h_name": "[ComputerName]",
......

If the unique identfier from the DB is not descriptive enough to be useful as the asset name, then you could always concatenate this and another column in the SQL query to create a value to be used as the unique identifier. 

If you still have issues, it may be worth posting the relevant extract from your conf file here (obviously ensuring not to post any sensitive or password/security information). 

Kind Regards

Bob

[Everton1878]

Hi Bob,

I've made a change to the config file and ran the import twice

It didn't duplicate anything, I'll keep my eye on it and run some more tests

Thanks for your help,

Pete