[SAMP\NDS] Queries related to Normalization Data Services


Description

Scenario-1:

Steps to reproduce:

1. Login to the instance
2. Navigate >> Normalized Company Names >> Click New and add the name as "Normalized Company"
3. In the Related links under Normalized Mappings >> Click New and created 2 mappings as

a. Normalized Company
b. Not Normalized Company

4. Navigate >> core_company and Click new and create Core Companies as

a. Normalized Company
b. Not Normalized Company

5. For the core_company that are created, the Normalized Company mapping is not being set.

Scenario-2:

Steps to reproduce:

1. Login to the instance
2. Navigate >> Linux Server >> Create one CI record with Manufacturer as "Adobe"
==> Could see the Manufacturer changes to "Adobe Systems" i.e. it gets changed to Normalized "Adobe Systems"

3. Similarly, goto alm_hardware table and create a new asset for Linux Server and select Company = "Adobe"
==> Could see the Company field will not get Normalized i.e. doesn't change to "Adobe Systems"


Release or Environment

Cause

Resolution

Scenario -1:

1. 'Name' of core_company should be as the value of 'Normalized Name' column on "Normalized Company Mapping" record
2. Value of 'Table' column on "Normalized Company Mapping" record should be 'core_company'
3. Value of 'Field' column on "Normalized Company Mapping" record should be 'name'

Scenario -2:

a. Canonicalize Manufacturer Company CI, and
b. Canonicalize Manufacturer Company Model.