HAM Model Normalization manual steps

[Amit Nemade]

Hi,

After completing the normalization process, I need guidance on the subsequent steps, specifically regarding how to handle and address data that hasn't been normalized. Additionally, I would like to know where to retrieve data for categories such as "Match Not Found," "Partially Normalized," and "Manufacture Normalized" for Excel reporting, as well as the procedure for uploading the revised data back into the system.

[Amarjeet Pal]

Hello @Amit Nemade ,

• Review the dataset to identify records that didn't meet normalization criteria.
• Categorize these records based on why they weren't normalized (e.g., "Match Not Found," "Partially Normalized").

For correction : 

• For non-normalized data involves manual review or additional cleansing.

Once you have reviewed the data, plan for re-importing it ensuring all corrected data meets normalization standards so that the error chance will be minimized.

For reports you can use below conditions:

• • Match Not Found: Set condition where normalization status equals 'Match Not Found'.
  • Partially Normalized: "                                                                 " 'Partially Normalized'.
  • Manufacture Normalized: "                                                " equals 'Manufacture Normalized'.

export the reports into Excel, review the data, and plan to upload revised data back to ServiceNow.

You can use load data , transform map for uploading the revised data.

Hope this is very much clear. Please mark helpful if it has helped you or given you a start for driving the things.

 

[Kalpeshjathar30]

Here's a breakdown to guide you through handling and addressing data that hasn't been normalized, retrieving specific data categories for reporting, and uploading revised data back into ServiceNow:

Handling and Addressing Data That Hasn't Been Normalized

1. Identify Unnormalized Data:

   - In ServiceNow, use the HAM (Hardware Asset Management) or SAM (Software Asset Management) module to identify assets that have not been normalized.

   - Create a report or a saved search to filter and view unnormalized records. Look for categories such as "Match Not Found," "Partially Normalized," and "Manufacture Normalized."

1. Review and Correct Data:

   - For assets categorized as "Match Not Found," manually review the asset data to ensure that all required fields are correctly populated.

   - For "Partially Normalized" assets, identify the missing or incorrect data that prevents full normalization. This often involves verifying manufacturer names, model names, and other key attributes.

   - "Manufacture Normalized" means the manufacturer data is correct, but other details might still need normalization. Ensure all necessary data fields are complete and accurate.

1. Utilize Normalization Suggestions:

   - ServiceNow often provides suggestions for normalization. Use these suggestions to update asset records.

   - If automatic normalization fails, manual intervention may be necessary to update asset records accurately.

 Retrieving Data for Categories in Excel Reporting

1. Generate Reports:

   - Navigate to the Reports module in ServiceNow.

   - Create new reports based on the criteria for "Match Not Found," "Partially Normalized," and "Manufacture Normalized" assets.

   - Customize the report to include necessary fields and filters.

1. Export Reports to Excel:

   - Once the reports are generated, use the export functionality to download the data in Excel format.

   - Ensure that the exported data includes all relevant fields for further analysis and correction.

 Uploading Revised Data Back into ServiceNow

1. Prepare the Excel File:

   - Use the exported Excel file to make corrections to the asset data. Ensure that all required fields are accurately populated.

   - Maintain the structure and format of the Excel file as per ServiceNow import requirements.

1. Importing Data into ServiceNow:

   - Navigate to the Data Import module in ServiceNow.

   - Create a new Data Import set or use an existing one.

   - Upload the revised Excel file to the Import set.

   - Map the fields in the Excel file to the corresponding fields in the ServiceNow table.

   - Run the data import job and review the import logs to ensure all records are imported correctly without errors.

1. Validation and Re-Normalization:

   - After importing the revised data, validate the changes to ensure that the records are updated correctly.

   - Re-run the normalization process on the updated records to achieve full normalization.