When using custom filter inputs for selecting the synchronization source "Microsoft 365 - Azure Directory / Entra ID / Global Address List / GAL (internal user list)" ("Global Address List"), all filter expressions are possible according to the Microsoft documentation.
Standard Filters
The following filters are applied automatically and without separate input:
Standard Filter | Meaning |
---|---|
userType eq 'Member' | Only genuine users in the Microsoft 365 Azure Directory |
accountEnabled eq true | Only active users |
Examples of Custom Filters
The following filter expressions can be defined in addition to the standard filters.
Example | Meaning |
---|---|
startswith(companyName, 'Meyer') |
Only Microsoft 365 users whose company name starts with "Meyer" |
startswith(givenName, 'O') | Only Microsoft 365 users whose first name starts with "O" |
city eq 'Frankfurt' | Only Microsoft 365 users from the city "Frankfurt" |
onPremisesExtensionAttributes/extensionAttribute1 eq 'yes' |
Only Microsoft 365 users whose custom extension "extensionAttribute1" has the value "yes" |
onPremisesExtensionAttributes/extensionAttribute1 ne null | Only Microsoft 365 users whose custom extension "extensionAttribute1" not equals value "NULL" |
extension_TENANT_ID_msExchExtensionAttribute17 eq '01' |
Only Microsoft 365 users whose custom extension "extensionAttribute17" has a value of "01".
Important! Since Microsoft Extension attributes > number 15 are only allowed in the Beta Graph API, an adjustment from sync.blue® support for the affected connection is necessary in advance! |
endsWith(mail,'@microsoft.com') |
Only Microsoft 365 users whose email address ends with "@microsoft.com". |
businessPhones/any(p:startsWith(p, '%2B49 5661')) |
Only Microsoft 365 users whose business phone number begins with "+495661" |
... | .. |
Here Microsoft describes additional user properties that can be used for filter expressions.
Comments
0 comments
Please sign in to leave a comment.