Normalization Lab
Enter a model or pick a preset. Click Run Normalization and watch the engine match, remap, or reject.
Input Model
table
name
manufacturer
model_number
Product Catalog
PowerEdge R750
Dell Inc. · R750
ProLiant DL380 Gen10
Hewlett Packard Enterprise · DL380G10
ThinkPad T14 Gen 3
Lenovo · T14G3
MacBook Pro 16-inch
Apple Inc. · MBP16
Catalyst 9300
Cisco Systems · C9300
Normalization Pipeline
Input
cmdb_model
Catalog Match
product catalog
Result
pending
Asset Ref
unchanged
Pick a preset or enter a model, then click Run Normalization.
How It Works
1. Model lands on cmdb_model
A record appears on the generic cmdb_model table — typically via CSV import, manual creation, or auto-stub when a CI references a model that doesn't exist yet. Discovery populates CI tables, not cmdb_model directly.
2. Normalization engine runs
HAM compares the model name, manufacturer, and model number against the product catalog. It scores matches by exact name, aliases, and model number.
3. Status is set
Normalized — high-confidence match (≥0.85). Model promoted to cmdb_hardware_product_model.
Review — partial match (0.5–0.84). Needs manual confirmation.
Not Normalizable — no viable match. Model stays on cmdb_model.
4. Asset reference updates
If normalized, the asset's model reference is remapped from the original cmdb_model record to the normalized cmdb_hardware_product_model record. If not normalized, the reference stays unchanged.