Sys Object Source table

[Katie A]

Hello, I am working on a custom integration with SCCM and Casper.

I noticed that the SCCM Plugin (which we are not using) populates the Sys Object Source table and stores the correlation ID for each imported record.

I'm not doing this for my version of the integration.

What is the purpose of that table and how do I populate it dynamically on import?

Thanks!

[Katie A]

Hello does anyone have any information on the Sys Object Source table?

Thanks!

[scotthal]

I don't believe this is documented much, but this is used by the SCCM plugin in as the primary key.   This id comes from the resourceid field in SCCM.   If a record isn't found in the sys_object_source table the script then goes off using other reconciliation methods.   In my opinion this code looks like spaghetti as it's been refactored over the years by ServiceNow to play nicely with both traditional discovery and now ServiceWatch, later called Service Mapping.   It could use some refactoring to make it easier to follow the logic.