Many records getting created in Core Company table

[AlexP1]

Hello,

We are having an issue that many records are getting created in the Core Company table. I have two questions:

1. I am aware why ServiceNow is creating records in the Core Company table. When a manufacturer attribute value for a CI is discovered and the value is missing in the Core Company table it creates a record. What is the best way to handle those records since there are too many and our the client is not happy with that? We use Normalization but it doesn’t clear the records from the company table, it just normalizes them.

2. We have noticed that we have records that are coming from Manufacture but in the Core Company table the manufacture field is set to false. Could you please tell me why this is happening?

Thank you!

[Patrick DeCarl1]

Check out https://community.servicenow.com/community?id=community_article&sys_id=ab5dcf2fdb3fff00fff8a345ca961...

It is normal for company table to have all these values. If you installed and setup "Normalization Data Services" it should help control what values users can see outside the company table. It will not clear them up since its needed for mapping to the normalize value. If discovery is creating the new manufacture record it will set the flag too true. 

[ctsmith]

With SCCM transform, I used the following onAfter script:

var setManFlag = new GlideRecord('core_company');
setManFlag.addQuery('sys_id', target.manufacturer);
setManFlag.addQuery('manufacturer', false);
setManFlag.query();
if (setManFlag.next()) {
setManFlag.setValue('manufacturer', true);
setManFlag.update();
}