Why do I have over 500,000 network adapter ci's in cmdb

[Thor A Simensen]

I only have about 20,000 computers, servers, and network devices in the cmdb, but have over 500,000 network adapter ci's.   Is this normal, or is there something I don't have configured right?

[jdiegeliv]

I was looking at this same issue and would like to thank those of you who explained what was going on with the SCCM database.

To address this, my thinking is to modify the following in the SCCM 2012 v2 Network transform map

1) Set Coalesce to False on the mac_address field map

2) Add a field map for Correlation ID with Coalesce = True

3) Delete all cmdb_ci_network where Correlation ID is empty and Created By is SCCM

Thoughts?

[Lauren Foster]

Hi @jdiegeliv, We are seeing the same issue, and I'd like to know if your solution worked?

[jdiegeliv]

We're upgrading to NY at the moment and I'm going to put it in when that is done.

That said, I did create a HI case and they agreed with the approach.

[jdiegeliv]

Hey, heads up. The solution worked as expected.

[Bob Kolosky2]

Note: The above works, but will only have one network adapter per SCCM resource ID (computer). If you add the Name field as the second coalesce value (in addition to Correlation ID), then you will have one adapter per unique name (e.g. ndiswan, e1dexpress, e1i65x64, vwifimp), which should be the desired behavior.