Office 365 (O365) Discovery Filters (v2.7.28 and newer)2019-03-26 11:44:01
Office 365 UnitySync
The information in this article applies to UnitySync versions v2.7.28 and newer. For older versions, please see the v2.7.27 article.
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.
Since the O365 discovery query filter format now looks/functions like LDAP query filters, you may reference the UnitySync Admin Guide for an overview of typical LDAP query syntax.
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. i.e.
Broken: (& (windowsemailaddress=*abc.com) (office=New Albuquerque ) )
OK : (&(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 at firstname.lastname@example.org.