Asset Import from Intune

[Everton1878]

Hi,

I'm looking to get the h_owned_by field populated for mobile phones from our Intune environment

However, userDisplayName give "Firstname Lastname" and userPrincipalName gives the email address of the user

Is it possible in the json file to trim userPrincipalName to give the name part before the @ symbol?

That would then match with our Hornbill user IDs and populate the name

Thanks

[SamS]

Hi @Everton1878,

You might be able to use the HornbillUserIDColumn property in the configuration file: https://docs.hornbill.com/data-imports-guide/assets/configuration

[Everton1878]

Perfect 

[Steve G]

Hi @Everton1878,

The asset import template functionality supports all the functions available in the Sprig template package, so you could use the trimSuffix, replace, regex etc functions to manipulate your data at template level: https://masterminds.github.io/sprig/strings.html

An example of using replace could be:

"h_owned_by": "{{ .userPrincipalName | replace "@yourdomainname.onmicrosoft.com" "" }}",

 This would remove @yourdomainname.onmicrosoft.com from the userPrincipalName being mapped into your target field.

Hope this helps,

Steve

[Everton1878]

thanks @Steve G