SCCM Graph Connector- Empty Source Field and Colease - Robust Transform Map

Abish · ‎09-12-2022

Hi

I am working on Service Graph Connector for Microsoft SCCM plugin. In the Robust transform map I see the below mapping.

Question 1 :The source field is empty and I am not sure how this value will be picked up?

Question 2 : Also I see the colease field (Use unique Input set field) is set to u_multi_instance_computer_snk field which in turn is mapped to disk-computer.source_native_key. But I am not able to find "disk-computer.source_native_key" in the target table.

Does any one has the colease field list for the SGC-SCCM Robust Transforms?

Thanks and Regards

Abish R

Report Inappropriate Content · ‎09-12-2022

Question 1 :The source field is empty and I am not sure how this value will be picked up?

Source native key is a field used by the IRE for identification by populating the sys_object_source table. This field represents a unique identifier out of the source system. In SCCM's case this is a jdbc connection to a database. This value is populated by the connection id, device id, and resource id. Connection id comes from the ServiceNow connection while device id and resource id are database indexes in SCCM. There is no situation where this will result in an empty value:

Question 2 : Also I see the colease field (Use unique Input set field) is set to u_multi_instance_computer_snk field which in turn is mapped to disk-computer.source_native_key. But I am not able to find "disk-computer.source_native_key" in the target table.

As mentioned in the response to question 1, the source native key field is not on the target cmdb class but rather in sys_object_source. Please read up here for some more information.

View solution in original post

Report Inappropriate Content · ‎09-14-2022

Abish,

I apologize I didn't notice the literally empty source field in the mapping. I'm guessing you have issues on upgrade. Go to System Diagnostics -> Upgrade History then filter where to =sn_sccm_integrate and review the skipped changes. There is likely a skipped change for that mapping. The only other way that would be empty is if it was removed as a customization. In that case you should check your update sets for changes.

Abish · ‎09-19-2022

Jgates,

Actually I installed the plugin on my PDI fresh and the source was empty there also. One thing I noticed was whenever the Source field is empty then the Referenced entity has some value. I noticed this in all the mappings. My understanding is that whenever the Source field is empty I think as you said it is referencing the Multi source instance key to find out the record.

Please let me know if you think there is a different way. Thanks for your reply.

Regards

Abish R