We are looking to move asset management solution to AMX and one of the important requirement is to normalise the incoming model information to the known model information within AMX. (this may need to be extended to Vendor / brand etc but that's for later)
Basically there are various distinct (and disconnected ) sources from where asset information is received in the asset management tool e.g. manually populated CSVs by different teams, extract from other systems not connected to asset manager, cmdb and various other CSVs and data dumps.
It is not possible for all those disconnected data sources to provide reference information (like Model) in the consistent manner which is known by Asset manager tool and in fact they can even contain some typos, special characters, spaces etc.
e.g. Incoming records may contain same model info but in different format like Pro Book 654, proBook654, PROBOOK654, probook-654, probook 654, "pro book 654", pro_book_654, .... so on
Whereas Asset Manager contains a valid model called probook654
Any idea how it can be done effectively in SMAX as this is very important functionality to onboard customer to AMX.
There's no possibility to enforce the normalised model process on all those disconnected data sources supplying device data for AMX and such procedure cannot be relied upon either. Thus, it seems far better to normalised the value within AMX at the point of regular imports