Suppress Companies from being created from SG-SCCM Software import with Chinese characters

[HeyMarkWarmack]

Hello All - During the Service Graph for Microsoft SCCM import, COMPANIES entries are being automatically created every day from the Software import.

We spent a lot of time cleaning up the Companies table and I am looking for a quick solution to suppress them being auto created at all.  I don't want to interrupt the Software import but want to keep the Company list clean.

It seems to be isolated to four main company names, see below, and all have Chinese characters.

I have a feeling that one is a full install and a custom install might be able to remove the language pack but still would like to suppress the creation in the Company table.

EXAMPLE of Companies created:

Intel Corporationﶬ벟ሀ耀HKEY_LOCAL_MACHINE
Intel Corporation뼌�Ԁ耀HKEY_LOCAL_MACHINE
Intel Corporation葆�཯谀
Illumio Inc.헡⠀耀Software
Illumio Inc.璨頑ᬀ耀Uninstall
Illumio Inc.꩖䊮ᑤ谀Microsoft
Audinate Pty Ltd࠷桸⌀蠀

ZOLL Medical Corporation倨똜Ѐ耀Microsoft Ed...
ZOLL Medical Corporation踨蟢Ѐ蠀
ZOLL Medical Corporationᰀ蠀

Thank you for any advice.

[tobycomer1]

Hi Mark, our client was having the same issue. Instead of preventing the companies from being created, it may be easier to use regex to slice the string after the non-ASCII characters. 

You can read more about our findings here:

https://relay.semaphorepartners.com/articles/orphan-companies-with-strange-characters-being-created-...

[dreinhardt]

Hi @HeyMarkWarmack,

and you should also check out the SAM Ranger Youtube video about Installing and Configuring Normalization Data Services. The normalization data service will help to keep the fields on each form clean and 1) allows only normalized records to be selected and 2) updates all records to a normalized on -> all different Intel records will be linked to the normalized record "Intel Corporation".

Based on this, we almost ignore the core_company table and rely on normalized records or reviews records with Vendor/Manufacturer flags.

Best, Dennis