Normalize Product Model Name

Overview

In the context of asset management, normalized product names refers to the process of standardizing names of products, software, or hardware to ensure consistency and accuracy within the system. This standardization helps improve data quality, reduce errors, reduce duplicates, and facilitates reporting and analysis.

Normalization Rules

There are a variety of tools and techniques that can be used to standardized product names. In general the following are used with the ESM system.

  1. In general drop (i.e. do not include) the manufacturer's name from the model (e.g. "Optiplex 7780" not "Dell Optiplex 7780")
    • The manufacturer name is captured in a specific attribute.
    • Some manufacturer's include their name/abbreviation as part of the product (e.g. LG gram) in which case the manufacturer name is retained.
  2. Use the vendor's descriptive advertised/marketing name (e.g. "ThinkPad P51 (Type 20HH, 20HJ)" not "20HJS0ET00").
  3. Use descriptive unique labels (e.g. "Mac mini (2023 with M2)" not "Mac mini").

Examples of Normalization

The following are a few examples of standardized product model names.

Examples of Product Model Name Standardization
Source Model Name ESM Standardized Model Name
17Z90Q-K.AAC7U1 LG gram 17" (2022)
930XCJ/931XCJ/930XCR Galaxy Book Ion
20HJS0ET00 ThinkPad P51 (Type 20HH, 20HJ)
CBX3___ Optiplex 9010
HP All-in-One Desktop 24-cb1xxx All-in-One 24-cb1066xt
iMac (24-inch, 2023) iMac (24-inch, 2023, Four ports)
Mac mini Mac mini (2024)
MacBook Pro (13-inch, 2018/2019, Four Thunderbolt 3 Ports) MacBook Pro (13-inch, 2019, Four Thunderbolt 3 ports)
Vivobook Go E1504FA_E1504FA Vivobook Go 15 Laptop (E1504F)

Need additional help or have issues

For support, requests may be submitted anytime using the appropriate Enterprise Service Management form. Requests generate a Ticket which will be worked in order received and urgency by IT Employees with the knowledge and permissions to assist with the request.

For immediate assistance please review the Contact Us page for the appropriate support group.

Print Article