SOLVED
Home

Change user DisplayName attribute when synching from local AD to O365?

%3CLINGO-SUB%20id%3D%22lingo-sub-185881%22%20slang%3D%22en-US%22%3EChange%20user%20DisplayName%20attribute%20when%20synching%20from%20local%20AD%20to%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185881%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20change%20the%20DisplayName%20attribute%20of%20a%20user%20getting%20synched%20from%20local%20AD%20to%20O365%3F%3C%2FP%3E%3CP%3EThe%20reason%20is%20that%20in%20local%20AD%20our%20users%20have%20the%20schema%3A%20lastname%20%2B%20firstname.%20However%2C%20we%20would%20like%20them%20ti%20exist%20as%20fistname%20%2B%20lastname%20across%20O365.%20Can%20this%20attribute%20mapping%20be%20altered%3F%3C%2FP%3E%3CP%3EWe're%20using%20Azure%20AD%20Connect%20to%20synch%20our%20on%20prem%20local%20AD%20users%20to%20O365%20%2F%20SharePoint%20but%20we%20have%20no%20Azure%20premium%20subscription.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-185881%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-194990%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20user%20DisplayName%20attribute%20when%20synching%20from%20local%20AD%20to%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-194990%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20is%20using%20MIM%2C%20this%20may%20help%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-identity-manager%2Freference%2Fmim2016-functions-reference%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fmicrosoft-identity-manager%2Freference%2Fmim2016-functions-reference%3C%2FA%3E%2C%20if%20not%20look%20for%20old%20documentation%20from%20Forefront%20Identity%20manager.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-186233%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20user%20DisplayName%20attribute%20when%20synching%20from%20local%20AD%20to%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186233%22%20slang%3D%22en-US%22%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F58%22%20target%3D%22_blank%22%3E%40Vasil%20Michev%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EYou%20can%20certainly%20edit%20the%20sync%20rules%2C%20but%20don't%20forget%20that%20they%20might%20get%20overwritten%20with%20updating%20AAD%20Connect%2C%20thus%20causing%20all%20DisplayNames%20to%20revert%20to%20default.%20There's%20an%20example%20in%20the%20documentation%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Fconnect%2Factive-directory-aadconnectsync-change-the-configuration%23use-an-attribute-other-than-the-default%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Fconnect%2Factive-directory-aadconnectsync-change-the-configuration%23use-an-attribute-other-than-the-default%3C%2FA%3E%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3EThanks.%20I%20read%20that%20article%20and%20it%20was%20very%20helpful.%20I'm%20in%20the%20middle%20of%20creating%20the%20new%20sync%20rule.%20However%2C%20I'm%20having%20trouble%20with%20the%20syntax%20to%20create%20an%20expression%20for%20the%20transformations%20option%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20940px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F32850iC111E7F7F4D69B24%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22mstsc_2018-04-24_09-26-12.png%22%20title%3D%22mstsc_2018-04-24_09-26-12.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20think%20that%20in%20order%20for%20the%20AD%20attribute%20'displayName'%20to%20have%20lastname%2Ffirstname%20reversed%20I%20hav%20to%20put%20some%20kind%20of%20expression%20here.%20What%20syntax%2Flanguage%20is%20this%3F%20Is%20it%20the%20same%20code%20that%20Excel%20would%20accept%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%2C%20in%20your%20linked%20article%20under%20the%20section%20%3CEM%3EChanging%20the%20userPrincipalSuffix%3C%2FEM%3E%3C%2FP%3E%3CP%3Ethere's%20an%20example%20for%20what%20to%20put%20in%20the%20'source'%20field%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EuserPrincipalName%3CSPAN%3E%26nbsp%3B%26lt%3B-%26nbsp%3B%3C%2FSPAN%3EWord(%5BuserPrincipalName%5D%2C1%2C%22%40%22)%20%26amp%3B%20%22%40contosotest.com%22%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20for%20your%20help.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-186072%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20user%20DisplayName%20attribute%20when%20synching%20from%20local%20AD%20to%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-186072%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20certainly%20edit%20the%20sync%20rules%2C%20but%20don't%20forget%20that%20they%20might%20get%20overwritten%20with%20updating%20AAD%20Connect%2C%20thus%20causing%20all%20DisplayNames%20to%20revert%20to%20default.%20There's%20an%20example%20in%20the%20documentation%3A%20%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Fconnect%2Factive-directory-aadconnectsync-change-the-configuration%23use-an-attribute-other-than-the-default%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fazure%2Factive-directory%2Fconnect%2Factive-directory-aadconnectsync-change-the-configuration%23use-an-attribute-other-than-the-default%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-185885%22%20slang%3D%22en-US%22%3ERe%3A%20Change%20user%20DisplayName%20attribute%20when%20synching%20from%20local%20AD%20to%20O365%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-185885%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Florian%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAs%20far%20as%20i%20am%20aware%20the%20value%20is%20taken%20from%20on%20your%20on-premises%20AD%20and%20hence%20trying%20to%20change%20the%20AD%26nbsp%3Battribute%20mapping%20might%20not%20be%20the%20answer%20to%20your%20solution.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20havent%20tested%20it%20though%2C%20but%20will%20try%20and%20let%20you%20know.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%2C%3C%2FP%3E%3CP%3EPrashant%20D%3C%2FP%3E%3C%2FLINGO-BODY%3E
Florian Hein
Regular Contributor

Hello,

 

is it possible to change the DisplayName attribute of a user getting synched from local AD to O365?

The reason is that in local AD our users have the schema: lastname + firstname. However, we would like them ti exist as fistname + lastname across O365. Can this attribute mapping be altered?

We're using Azure AD Connect to synch our on prem local AD users to O365 / SharePoint but we have no Azure premium subscription.

 

Thanks in advance for your help.

4 Replies

Hello Florian,

 

As far as i am aware the value is taken from on your on-premises AD and hence trying to change the AD attribute mapping might not be the answer to your solution.

 

I havent tested it though, but will try and let you know.

 

Regards,

Prashant D

Solution

You can certainly edit the sync rules, but don't forget that they might get overwritten with updating AAD Connect, thus causing all DisplayNames to revert to default. There's an example in the documentation: https://docs.microsoft.com/en-us/azure/active-directory/connect/active-directory-aadconnectsync-chan...


@Vasil Michev wrote:

You can certainly edit the sync rules, but don't forget that they might get overwritten with updating AAD Connect, thus causing all DisplayNames to revert to default. There's an example in the documentation: https://docs.microsoft.com/en-us/azure/active-directory/connect/active-directory-aadconnectsync-chan...


Thanks. I read that article and it was very helpful. I'm in the middle of creating the new sync rule. However, I'm having trouble with the syntax to create an expression for the transformations option:

 

mstsc_2018-04-24_09-26-12.png

 

I would think that in order for the AD attribute 'displayName' to have lastname/firstname reversed I hav to put some kind of expression here. What syntax/language is this? Is it the same code that Excel would accept?

 

For example, in your linked article under the section Changing the userPrincipalSuffix

there's an example for what to put in the 'source' field:

 

userPrincipalName <- Word([userPrincipalName],1,"@") & "@contosotest.com".

 

Thanks for your help.

It is using MIM, this may help https://docs.microsoft.com/en-us/microsoft-identity-manager/reference/mim2016-functions-reference, if not look for old documentation from Forefront Identity manager. 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies