Question on transform map

[pot]

Hi All,

We have an integration between ServiceNow and Intune , and there is schedule job which will run everyday at 12:00 am . As part of this integration we are importing computer devices  from Intune , now challenge is there are few cases where multiple records are associated with same serial number . In ServiceNow we have defined serial number as coalesce field due to client requirement , if there are multiple records with same serial number then we have to import only one record as per last check in date , if last check in date is latest one then import only that record and ignore all other records with same serial number . is there any possibility to achieve this requirement , if yes how can we achieve ?

@Maik Skoddow 

Thanks in advance.

[Maik Skoddow]

Hi @pot 

how exactly are you importing? Hopefully not with a traditional import set / transform map approach because that way you bypass the IRE.

In case your integration approach leverages the IRE: And have you defined all required rules in the CMDB class manager to make sure that such situations with duplicated serial numbers are mitigated?

Maik

[pot]

Hi Maik,

We are utilizing transform map through integration . Even i don't think that we can control through IRE for above use case.

[Prabu Velayutha]

Hi @pot 

I have implemented Intune for multiple customers. Common issue with the Intune source was Multiple records having same serial number, this was because when the same asset is reassigned to different user when they leave the company or transfer to different department. So, CI with duplicate serial number could be an issue with the Intune data source which requires clean up.  

consolidate the duplicate Serial numbers and report to Intune to fix or clean up. Clean data from source is more important rather than fixing in target.

If my response helps to solve your issue. Kindly mark it as helpful & correct. It will be helpful for future readers!