Why 2 tables: cmdb_model & cmdb_hardware_product_model?

[Jim L2]

We've been working to clean-up our cmdb_hardware_product_model table (eliminating duplicates and getting all the assets pointed to the correct models) when I discovered a large number of assets pointed to models in the cmdb_model table instead.  Looking at the 2 tables, there are many models that appear in both.  What are the purposes/differences between these 2 tables?

[David Casper]

The hardware table simply extends the Product Model table meaning it inherits all the fields from product model but then can have it's unique fields that don't apply to other model tables such as software, etc.

So when you look at the product model table you are going to see ALL product model types. When you look at the Hardware Model table you will ONLY see the hardware models. 

Hope that helps!

[SriChaitanV]

Ensure that the models in cmdb have their class set to "hardware model"