SCCM Integration Mapping question

mdidrikson
Kilo Contributor

‎01-24-2012 09:15 AM

Hello,

We are setting up an SCCM configuration and we have pulled our data into Service-Now via the Mid server. We are in the process of testing the process and one of the issues we have is we would like to have is the mapping from SCCM to Service-Now CMDB.

SCCM Resource ID maps to Correlation ID in Service-now CMDB. It is also the field that is used to match records between Service-now and SCCM. The problem is that a new Resource ID is created every time a device is added to SCCM. We would like records to match on the Serial number field.

Can we get Service-now to match on the serial number field? Is this controlled though a transformation?

Thanks for your help!

Mark Didrikson

0 Helpfuls
  • 6,246 Views
19 REPLIES 19

rgarland
Kilo Contributor

‎01-24-2012 11:44 AM

Mark, we have done this integration at our company and are matching on Serial Number, sort of. The issue is with SCCM and not Service-now. SCCM only stores Serial Number in the PC BIOS table along with the Resource ID/Machine ID which is what we have been using to map to Correlation ID in Service-now. This is controlled through the transform map on the Data Source. If you look at Data Sources under the SCCM Integration app and open the PC BIOS data source you will see Serial Number and Resource ID / Machine ID. That's where you could change the coalesce value. However since Serial Number is not known to the other tables coalescing on it only helps with the PC BIOS import and it doesn't help with your issue of duplicate entries of the same serial number when a device is added to SCCM. I would be glad to discuss our experience in more detail with you if you like.


0 Helpfuls

mdidrikson
Kilo Contributor
In response to rgarland

‎01-24-2012 12:38 PM

Hi,

Yes, I would be interested in hearing more about your implementation. I was seeing the same thing as you in the PC Bios data source and I was thinking of updating the coalesce value.

Thank you.

Mark Didrikson


0 Helpfuls

rgarland
Kilo Contributor

‎01-24-2012 01:40 PM

Email me at rick.garland@pxd.com and we can setup a time to discuss.


0 Helpfuls

gmat11
Kilo Explorer

‎03-21-2012 03:37 PM

My company is relatively new to ServiceNow (we went live just after Thanksgiving of 2011). We are getting duplicate entries for computers because, as I understand it, each time a computer is re-imaged SCCM generates a new machineID, which is then mapped to a new correlation ID, which then creates a duplicate entry in the CMDB for the same serial number.

I was thinking about using serial number as a coalesce, but as was pointed out, serial number isn't used in all tables.

Is there anyone else out there who has looked into this issue? If so, what were your possible solutions?


0 Helpfuls