Duplicate Models in cmdb_hardware_product_model table

[pramodkumar]

Hi All,

We have multiple discovery sources, and we’re seeing duplicate entries in the cmdb_hardware_product_model table. Each model is linked to configuration items (CIs). How can we clean up these duplicate models in the existing data, and how can we prevent different discovery sources from creating duplicate models going forward? How to find which source created model?

Thanks!

[Tejas Adhalrao]

Hi @pramodkumar  ,

You can identify duplicates in cmdb_hardware_product_model based on fields like:

• Name
• Manufacturer
• Model number

Use a report or group by these fields to find duplicates.

and you can Find Which Source Created the Model

Check the following fields on the model record:

• sys_created_by → user or integration जिसने record create किया
• sys_created_on → creation time
• sys_updated_by → last updated by
• Discovery Source (discovery_source) → sometimes populated

Also, check related CI:

• Open CI → check Discovery Source field
• This helps identify which integration (Discovery, SCCM, Service Graph, etc.) is contributing

[Tanushree Maiti]

Hi @pramodkumar 

1. How to Find Which Source Created a Model

   If enabled, you can use the Multisource CMDB Dashboard to see which data source most recently provided the model attribute for a given CI.

  Check the sys_created_by field. If created by Discovery, it may show "system" or a specific service account.

2. How to Prevent Future Duplicate Models

 Refer community posts : Best Practice for Dealing with Duplicate Software Models

                                    Duplicate hardware model getting created by ServiceNow Discovery and SCCM 

Also refer KB : KB1532059 How to de-duplicate software models 

3. How to Clean Up Existing Duplicate Models

a. Remediate models either by updated manually or by script.

b. Refer the script : Remove Multiple Duplicate Model Script help 

      ServiceNow Duplicate CIs Solution / Script / Report