question Re: ServiceNow Discovery, SCCM, & Data Precedence in ITOM forum

ServiceNow Discovery, SCCM, & Data Precedence

cloudyrobert — Wed, 26 Feb 2020 20:04:25 GMT

I've implemented the SCCM integration in our development environment (com.snc.integration.sccm2016). My intention is for SCCM to serve as the authoritative source for the devices it covers, supplemented by ServiceNow Discovery where there is not a conflict with data from SCCM. It appears that ServiceNow Discovery & the SCCM integration are overwriting each other. I've set up a Data Precedence Rule for both SCCM (priority 100) and ServiceNow (priority 200) on the cmdb_ci_computer table, yet ServiceNow Discovery continues to overwrite certain fields (disk space and name in particular) and relationships (disks, file systems, serial numbers).

My understanding is that the precedence rule should keep Discovery from overwriting fields set by SCCM. I'm aware that the SCCM integration does not honor the rules (https://hi.service-now.com/kb_view.do?sysparm_article=KB0748948), but shouldn't Discovery?

My questions:

Why isn't Discovery honoring SCCM as a source with higher precedence and not overwriting values sourced from SCCM?
Are relationships included in the precedence rule on the table so that when I resolve question 1's issue, the relationships will also stop being overwritten?

Re: ServiceNow Discovery, SCCM, & Data Precedence

patrickdeca — Thu, 27 Feb 2020 16:25:19 GMT

Can you share the steps you took?

Re: ServiceNow Discovery, SCCM, & Data Precedence

cloudyrobert — Thu, 27 Feb 2020 17:37:14 GMT

Not all of this is related, I don't think, but I believe this covers all that I've done...

Activated the plugin (com.snc.integration.sccm2016).
Configured the data sources for our environment.
Activated the AI jobs & deactivated the corresponding non-AI jobs for software.
Updated the computer identity data source SQL statement to pull TopConsoleUser
Updated the SCCM 2016 Computer Identity transform map
1. Commented out the call to "setAssignedTo()" in the script
2. Added a mapping for most recent discovery that sets the value to gs.nowDateTime()
3. Added a mapping for discovery source that sets the value to "SCCM"
4. Added a mapping for a custom "primary user" field set from the TopConsoleUser
Created two data precedence rules on cmdb_ci_computer from the CI Class Manager
1. Priority 100
2. 1. Data source: SCCM
  2. Applies to: Computer
  3. Active
3. Priority 200
4. 1. Data source: ServiceNow
  2. Applies to: Computer
  3. Active

Re: ServiceNow Discovery, SCCM, & Data Precedence

patrickdeca — Fri, 28 Feb 2020 15:52:31 GMT

Check out another thread with issue. https://community.servicenow.com/community?id=community_question&sys_id=c9985fb5db8b88d0d82ffb2439961928

In Orlando release a new SCCM integration is setup to use IRE. link below.

https://store.servicenow.com/sn_appstore_store.do#!/store/application/9a2ce8f60f80001067ae409dc4767e6f/1.0.2

Re: ServiceNow Discovery, SCCM, & Data Precedence

cloudyrobert — Thu, 12 Mar 2020 13:42:53 GMT

This does have to do with the SCCM integration not using the IRE, pre-Orlando. Since there are no entries in the cmdb_datasource_last_update table due to the integration not using the IRE, the data precedence rules aren't followed. The main cases for me are Name and OS Domain. There's a PRB (PRB691517) with a workaround for this in a KB (KB0753063) if you ask for access from HI. They use a couple of properties to change the way these fields are set to make the overwriting not a problem, but they're not a true fix of the underlying issue. We're now just seeing the Discovery source flip back and forth, which is OK until Orlando.

Re: ServiceNow Discovery, SCCM, & Data Precedence

CMDB Whisperer — Wed, 25 Mar 2020 16:29:40 GMT

That link says the version was withdrawn from the store.

Re: ServiceNow Discovery, SCCM, & Data Precedence

patrickdeca — Wed, 25 Mar 2020 16:40:59 GMT

If you take the 1.0.2 version off url you will be able to request the app.

https://store.servicenow.com/sn_appstore_store.do#!/store/application/9a2ce8f60f80001067ae409dc4767e6f/

Re: ServiceNow Discovery, SCCM, & Data Precedence

patrickdeca — Tue, 07 Apr 2020 21:01:52 GMT

Check out post I just made. https://community.servicenow.com/community?id=community_article&sys_id=e7202b51dbc4585c13b5fb24399619fa