Sccm graph connector is not collecting the IP address in computer class when we check cmdb_ci. Please help me with the exact process and SQL script to achieve it

[Nidhi Priya1]

Sccm graph connector is not collecting the IP address in computer class when we check cmdb_ci. Please help me with the exact process and SQL script to achieve it.

I integrated sccm and servicenow but i can see in cmdb_ci table that for "computer class", IP address is not visible. Please help me with the process and SQL query to achieve the same.

[#2 · Accepted solution]

Nidhi,

Please refer to this post.

In general it is bad practice to populate the ip address on the computer class.  A computer can have multiple network adapters and ip addresses.  Modeling ip address (and mac address) on the computer is not the best data modeling and can result in data thrashing.  IP address is also reserved for discovery and modifying this field with use of discovery can cause unexpected consequenses.

SCCM populates the cmdb_ci_ip_address class that can be viewed as a related list on the computer form.  This is the proper modeling.

[Nidhi Priya1]

Thanks a lot Gates,

Can I have some more information on the same. I need to convince my client for this. It would be really helpful if some more KB or any other doc from Servicenow is provided.

[#4]

For starters SCCM is models it this way.  It uses the v_GS_NETWORK_ADAPTER_CONFIGURATION table to store ip addresses and then relates those ip addresses back to the server using the ResouceId.  This results in multiple ip addresses for a single computer.  How would the client programatically determine which one of say 4 ip addresses to choose?  This would result in the ip address field on the computer frequently changing.

Here are a couple of KBs to look at:

Selecting the right IP address for devices with multiple IP addresses

One configuration item identified for multiple IP addresses