Jump to content

Changing the primary key mapping for asset imports from the asset tag/host name to the serial number


Recommended Posts

Hi All,

We have been looking to change our asset import configuration primary key from the current mapping to the asset tag/host name over to the serial number on the asset. 

We have made a test import configuration and imported one dummy asset. We then attempted an update to this new asset by changing just one of the data fields. On the second run this created a duplicate of the asset, and when reviewing the log file and attempting to update this dummy asset we note the below error message in the log file:

2022/10/13 09:55:37 Unable to Search for Asset: The search column 'h_serial_number' is not allowed

It appears that using the serial number is throwing the above error - is this correct?

Many thanks

 

 

 

Link to comment
Share on other sites

Hi @Adrian Simpkins,

In your AssetTypes import config, have you set the AssetIdentifier->Entity value to match the entity where h_serial_number lives, as per the wiki documentation and the configuration example?

If you're importing computer type assets and matching on h_serial_ number, the entity should be AssetsComputer as so:

"AssetIdentifier": {
    "SourceColumn": "SystemSerialNumber",
    "Entity": "AssetsComputer",
    "EntityColumn": "h_serial_number"
}

Cheers,

Steve 

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...