Massive number of duplicate Product Models

Marcel H_
Tera Guru

We've been using Discovery in our environment for a while now, and get a good amount of data back, though it could use some additional tweaking.

One thing that I've noticed, and I believe that Discovery aids in the creation, is that we have a massive number of duplicate Product Models in our system. I am very confident that all but a few were generated automatically from Discovery, and we now have 513,330 product models in the product model table, most of which are duplicates.

As an example, I know for a fact that we have 2 Dymo LabelWriter Print Servers on our network, but we have 311 product models, all listed as "LabelWriter Print Server". Others that I've seen that are also obvious duplicates include 17,710 for "3825" (which appears to be referring to a Cisco 3825), or 81,874 for a "Catalyst 37xxStack".

How can I consolidate these duplicates into single product models that are associated with CIs and Assets, and ensure that these huge number of duplicates aren't created again?

1 ACCEPTED SOLUTION

DaveHertel
Kilo Sage
Kilo Sage

Hi, have you looked in to using the field normalization plugin  To consolidate product models? Seems like a viable option...

find_real_file.png

Does this help?

View solution in original post

10 REPLIES 10

tshk
Giga Contributor

Hi Marcel,

I'm having the similar issue, i activated Normalization and tried to pick one set of records that all gets normalized to one single record (normalizing on display name of product Model). This doesnt seem to work unless the the model names are different. Suppose below is the records i'm working on 

Dell Latitude E5440

Dell Latitude E5440

Dell Inc. Latitude E5440

after normalizing it is showing me 2 records below, i also used coalesce but no luck

Dell Latitude E5440

Dell Latitude E5440

 

Any help on this would be highly appreciated