How to tackle large number of normalization suggestions

[Princess W_]

We have a large number of normalization suggestions (excess of 10,000). Does anyone have recommendation on how we can bulk review this records? Also, I know normalization suggestions assist with consistency of data with discovery models but I would like to know if there is a negative impact on SAM or ServiceNow if we do not accept/reject normalization suggestions?

[dreinhardt · Accepted solution]

Hi @Princess W_ 

to bulk review and accept normalization suggestion, I would recommend to use the table related to this process and accept/reject actions for all selected rows

• Navigate to table [samp_normalization_suggestion]
• All changes are highlighted with a "blue dot" for each field process by the service
• Select all rows you want to accept/reject
• Use the table action to perform your actions

Of course you should review and accept/reject the suggestions provided by the SAMP content service. 

Any suggestion will help you to increase your data quality and will correct or adjust existing manually normalized models.

10.000 suggestions is a lot, did you manually normalize a lot of models and added some incorrect data. Would be nice to know what kind of discovery models the service would like to update.

Best, Dennis

[Fatima S Sayyed]

@Princess W_ Additionally, you could also do this via background script/fix script, as doing this via UI is also time consuming.

Code snippet for reference - 

var gr = new GlideRecord("samp_normalization_suggestion");

gr.addEncodedQuery("filter of your choice");

gr.query();

while (gr.next()) {

gr.status = "approved";

gr.update();

}

[Princess W_]

Thank you for your response. We tried to use a script to update the status. It changed the status to 'approve' but it did not update the discovery model with the normalization status and the status remained 'Manually normalized'