Using regex in AAD Connect synchronization scoping filter

%3CLINGO-SUB%20id%3D%22lingo-sub-1386238%22%20slang%3D%22en-US%22%3EUsing%20regex%20in%20AAD%20Connect%20synchronization%20scoping%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386238%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20of%20a%20way%20to%20use%20regex%20in%20the%20Scoping%20filter%20in%20the%20AAD%20Connect%20synchronization%20Rules%20editor%20please%3F%3C%2FP%3E%3CP%3EI%20don't%20want%20to%20import%20in%20users%20with%20an%20incorrect%20UPN%2C%20all%20I%20want%20to%20come%20in%20are%20UPNs%20in%20the%20format%20of%20%3CA%20href%3D%22mailto%3Afirstname.lastname%40mydomain.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Efirstname.lastname%40mydomain.com%3C%2FA%3E%3C%2FP%3E%3CP%3EAt%20present%20I%20have%20about%20500%20users%20with%20incorrect%20UPNs%20that%20can't%20be%20immediately%20corrected%20due%20to%20remote%20working%20and%20corresponding%20certificates%20with%20UPNs%20like%20this%3C%2FP%3E%3CP%3E%3CA%20href%3D%22mailto%3Axx111%40mydomain.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Exx111%40mydomain.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22mailto%3Axx111%40subdomain.mydomain.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Exx111%40subdomain.mydomain.com%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22mailto%3Afistname.lastname%40subdomain.mydomain.com%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Efistname.lastname%40subdomain.mydomain.com%3C%2FA%3E%3C%2FP%3E%3CP%3EI've%20got%20a%20filter%20set%20up%20with%20Attribute%20%3D%20userPrincipalName%2C%20CONTAINS%2C%26nbsp%3B%40mydomain.com%3C%2FP%3E%3CP%3EThis%20makes%20sure%20most%20incorrect%20ones%20are%20caught%20but%20not%20the%20first%20in%20my%20list%20of%20examples.%20If%20you%20could%20use%20some%20regex%20I%20could%20NOTINCLUDE%26nbsp%3B%E2%80%9C%5E%5BA-Z%5D%7B2%7D%5B0-9%5D%7B3%7D%E2%80%9D%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20would%20also%20work%20if%20the%20value%20could%20take%20*.*%40mydomain.com%20but%20it%20doesn't%20look%20like%20wildcards%20are%20supported%20as%20it%20is%20asking%20for%20a%20definitive%20value.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%3C%2FP%3E%3CP%3EAndy%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1386238%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAAD%20Connect%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAAD%20Connect%20Server%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAzure%20AD%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1386919%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20regex%20in%20AAD%20Connect%20synchronization%20scoping%20filter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1386919%22%20slang%3D%22en-US%22%3E%3CP%3EI%20don't%20believe%20it's%20supported.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi all

 

Does anyone know of a way to use regex in the Scoping filter in the AAD Connect synchronization Rules editor please?

I don't want to import in users with an incorrect UPN, all I want to come in are UPNs in the format of firstname.lastname@mydomain.com

At present I have about 500 users with incorrect UPNs that can't be immediately corrected due to remote working and corresponding certificates with UPNs like this

xx111@mydomain.com

xx111@subdomain.mydomain.com

fistname.lastname@subdomain.mydomain.com

I've got a filter set up with Attribute = userPrincipalName, CONTAINS, @mydomain.com

This makes sure most incorrect ones are caught but not the first in my list of examples. If you could use some regex I could NOTINCLUDE “^[A-Z]{2}[0-9]{3}” 

It would also work if the value could take *.*@mydomain.com but it doesn't look like wildcards are supported as it is asking for a definitive value.

 

Thanks in advance

Andy

1 Reply
Highlighted

I don't believe it's supported.