Duplicate Models in cmdb_hardware_product_model table

pramodkumar
Tera Expert

3 hours ago - last edited 3 hours ago

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!

0 Helpfuls
  • 149 Views
1 REPLY 1

Tejas Adhalrao
Kilo Sage

59m ago

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
0 Helpfuls