Computers from SG-Intune have lowercase names

[MarLoi]

Hello!

One of the Service Graph Connectors used in our instance is SG-Intune.
This year, we have noticed that most computer names in the [cmdb_ci_computer] table ingested by SG-Intune are in lowercase, even when the corresponding values in the deviceName field of the import table contain uppercase letters.

However, there are also some computers for which the correct capitalization is preserved.

We investigated the glide.discovery.hostname.case system property, but it is set to "Lower case" and was last updated by ServiceNow in 2011.

It doesn't explain why some computers have the correct capitalization, instead of lowercase.

Through the IntegrationHub ETL, we also looked into the associated RTE Entity Script Operation [sys_rte_eb_script_operation], Script Operation - u_devicename, which transforms the import value into the value of the computer name field.

However, this was last updated by ServiceNow in 2024.

Are there any other possible leads we could investigate that might explain this inconsistency?

For example, could there be another conversion, normalization, or processing step taking place between the import table and the cmdb_ci_computer record that we should look into?

Thanks in advance for your help!

#discovery #sgc #intune #ci #computer #cmdb #ingestion

[matrixtushar]

Hi,

If its Microsoft Intune, I am sure its using the below Discovery Definition Property

Use this and your systems will be in UPPERCASE.

[Kiruthiga Kumar]

This property is available in global application.

If we update there, it will be applied to all the other discovery.

[matrixtushar]

Hi,

What stops you from envisioning that all the CIs discovered have a homogenized case? If you don't want to use the property then you can go for the "Before" Script on the robust transform. There you can convert the feed coming from inTune to UPPERCASE. 

Hope this helps.