Hi @Sumit Maheshwar ,
You are correct, Resource ID is the first thing that SG SCCM Integration uses in pre-IRE step to find a match before it actually calls IRE API. Service Graph connector for SCCM creates entries for all the records in sys_object_source with Resource ID | Connection ID and target sys_id and uses this record to find a match, if it does not finds match then it calls IRE and then create record in sys_object_source to use it for future updates.
Now even if you have multiple instances of SCCM Databases configured in your environment it fine because Resource ID | Connection ID is always going to be unique as Connection ID is unique for each SCCM instance. So in case you have Service Graph connector for SCCM then you don't have to worry about having same Resource Id in multiple SCCM instance.
-----------------------------------------------------------------
Now if you are still using SCCM 2012 old plugin and you have 2 Data sources and transform maps connecting 2 SCCM Databases then you have to modify your Computer Identity Data sources SQL to concatenate Site ID to be able to keep it unique.
We had old plugin with 2 instances and below is the select column which worked for us for many years (now we are using SGC)
In addition to this change you have to also add below Join condition as this new table is not part of OOTB query:
You have to do this in both Comp identity datasources.
Hope this helps. Do mark this Helpful or Accept Solution if it helps you resolve your issue.
Thanks,
Ashish
