PeopleSync Knowledge Base

Object Filters for AD / LDAP Agents

Every Person with either phone number or email address that is not disabled:

(&(|(telephoneNumber=*)(mail=*))(objectCategory=Person)(!(UserAccountControl:1.2.840.113556.1.4.803:=2)))


Every Person that is not hidden from Exchange address book and that has an email address from example.com or otherexample.com domains:

(&(!(msExchHideFromAddressLists=TRUE))(|(mail=*@example.com)(mail=*@otherexample.com))(&(objectClass=user)(objectCategory=person)))


Every Person that has either first name or last name and also phone or email address:

(&(|(telephoneNumber=*)(mail=*))(|(sn=*)(givenName=*))(objectCategory=Person))


Every Person that has either first name or last name and also mobile phone or phone:

(&(|(telephoneNumber=*)(mobile=*))(|(sn=*)(givenName=*))(objectCategory=Person))


Every Person with either phone number or email address that does not have extensionAttribute1 set:

(&(|(telephoneNumber=*)(mail=*))(objectCategory=Person)(!(extensionAttribute1=*)))


Every Person with either phone number, mobile or email address and either first or last name that is a member of group “Sales”:

(&(|(telephoneNumber=*)(mail=*)(mobile=*))(|(sn=*)(givenName=*))(objectCategory=Person)(memberOf:1.2.840.113556.1.4.1941:=CN=Sales,OU=Mitarbeiter,DC=contoso,DC=de))


For use in LDAP Agent, please see Using Object Filters in LDAP Agent