What is difference between table normalized_model and model_number

[Piyush Dwivedi]

When we see Hardware Model Table, Model number field is empty and when we get into the Model form, Model number is available in Normalization tab.

Technical name of blank Model Number field is "model_number"

 Technical name of populated Model Number field is "normalized_model"

so want to understand, Is there difference between table normalized_model and model_number?

[Community Alums]

Hi @Piyush Dwivedi ,

Both should be same.

You can learn more :https://www.servicenow.com/community/sam-blog/what-is-hardware-normalization/ba-p/2285107

[Ashok Sasidhara]

Model_number field will populate the model number based on how it was originally created. So it can be populated with a non-standardized name or even be empty sometimes. Normalization tab appears since you might be using HAM pro. So the normalized_model field will be populated by the HAM content service with the standardized name for that Model number. 

[Piyush Dwivedi]

Thanks for the response, Is that means that Model Number for an Hardware Item can't be discovered, It will only be populated via Content Service? 

and one more query, I can see Model Id is discoverable via SCCM and other tools but not Model number...Is Model number & Model ID are same?

[Ashok Sasidhara]

It may come via discovery or other data sources that populate the CIs for the corresponding asset records. But they may not always populate it or may often populate it with a value that is not standard. The purpose of content service is to populate the fields on the 'Normalization' tab by comparing the information populated initially with that present in the content service (the normalization status is based on which all fields the content service is able to populate).

Model ID in CMDB shows the entire name of the referenced model which might even include the model number as a part of it if populated. i.e. it is not the same as model number. 

Check whether the following system property is set to true. 

glide.cmdb.makeandmodel.use_model_number_lookup

If it is set to false, please set it to true. It enables to lookup the model number of hardware models through the MakeAndModelJS script.

Also look at a similar problem and solution suggested in the following URL:

https://www.servicenow.com/community/sam-blog/improving-hardware-and-consumable-product-model-normal...