Integration with Microsoft SCCM WITHOUT connector "Service graph connector for Microsoft SCCM"

[Sulabh Garg]

Hi All,

Please let me know if we can build the integration with Microsoft SCCM & ServiceNow to pull the data from ServiceNow in CMDB.

I understand it can be easily done from Service graph connector for Microsoft SCCM, However client does not want to do it with connector due to some license restrictions.

Can someone please guide me how to start the integration without connector, I just wanted to understand if someone has the same use case and how the integration was build without connector and what challenges you have faced.

Thanks in Advance.

[CMDB Whisperer]

Best I can tell you is that ServiceNow advertises it as free and has done so since the beginning.  It is the only Service Graph Connector that is free, but to my knowledge nothing has come out to change that fact, so my understanding remains that it is free, despite confusing documentation to the contrary.  That said, the usual disclaimer applies, that only your account rep can make accurate statements around specific subscription and licensing for your instances.

[Mark Bodman · Accepted solution]

Be mindful that we do not recommend importing CI data directly into tables, as this will bypass the identification and reconciliation rules for CI's that prevents duplicates, and will bypass multi-source feature if enabled as well.  All Service Graph connectors use IRE, so this consideration and using IRE is built-into them.  IRE documentation can be found here.
The metrics this will negatively impact is provided in the Data Foundations Dashboard, as hi-lighted below.  The Data Foundations Dashboard can be downloaded from the store as well.  Here is a video overview if you are not  aware of this critical feature to gauge your data management practices and quality.

There are a few health metrics associated to this problem that will start to show up and negatively impact your health scores.  

[Sulabh Garg]

Thanks @Mark Bodman for providing detailed explanation, So are you saying its not best practice to go with custom integration solution through JDBC data sources? As custom integration solution will not follow the IRE? If Yes, then is there any way to follow the IRE via custom integration solution through JDBC data sources?

[Sulabh Garg]

@ersureshbe - Thanks, But do you know how to follow the IRE before I create/update records in CMDB?

[ersureshbe]

Hi, If you refer the class manager you can define identification and reconciliation rules. I recommend to check the videos in YouTube and nowlearning portal to see the real time demo.

I strongly agree IRE is helping to use create and update the right ci. This concept is applicable for cmdb module. But ServiceNow provided the same option globally in import set table as well. 

Coalesce is helping to update the information.                            

Source script ie, sys_id is going to play the identification of the record. You should achieve through script and additionally you can define identification using priority as well. 

IRE is going to help to create and update the CI with the help of configuration. The same can possible in the import set table but strong code required(you can define very strong structure). Depends the business use cases you select the option. The servicenow recommendation use IRE for CIs.