With SG-SCCM version 2.5, Organization Unit (OU) information from SCCM is pulled in and populated in a related table. We are seeing cases where there are multiple OUs for a resource id (computer) which results in multiple computer records in the computer import set table. This will not result in duplicates in CMDB but could potentially increase the processing time for computer data source.

We have a defect (DEF0244656) opened for this issue -

https://buildtools1.service-now.com/nav\_to.do?uri=%2Fx\_snc\_defect\_defect.do%3Fsys\_id%3Dfca\[…\]84288%26sysparm\_record\_list%3DORDERBYDESCsys\_updated\_on

Work around to avoid duplicates in import set and not bring in OU information until the defect is fixed:

1. Open up SG-SCCM Computer Identity data source and go the SQL statement section2. Replace this SQL line:

v_RA_System_SystemOUName.System_OU_Name0 as OUName,