Filters: Office 365 (O365) Discovery (v2.7.28 and newer)2021-02-22 16:01:42
Office 365 UnitySync
The information presented here applies to UnitySync versions v2.7.28 and newer. If you are still on an older version, we urge you to upgrade to the latest for vastly improved handling of O365 objects, as v2.7 reached end of life on July 1, 2018.
As of version v2.7.28, the Office 365 (O365) filters have been tremendously simplified. Previously, they were formatted using the O365 specific syntax. As of this version, filters may be entered using what looks like a standard LDAP query filter.
IMPORTANT NOTE about O65 filter syntax:
When creating a filter for an O365 source, do NOT include extra space or symbols such as parentheses, pipe symbols (|) or ampersands (&). Presence of these characters or spaces will cause the filter to break.
(& (windowsemailaddress=*abc.com) (office=New Albuquerque ) )
(&(windowsemailaddress=*abc.com)(office=New Albuquerque ))
Additionally, there are a couple things specific to O365 to remember.
Wild card character asterisk (*) may be used.
For example, this query will discover all records where ‘Company’ contains ‘Partner’:
Certain reserved characters require the use of codes when used in a query filter. For example, this query will discover all records where ‘Displayname’ contains ‘[Consultant]’:
For \ use \5c
For / use \2f
For [ use \5b
For ] use \5d
For = use \3d
For * use \2a
If you have any questions about how to craft your query for O365 Discovery, please contact our Technical Support Team.
Please see this article for more information on using group membership (memberof) as a filter.