Hello All,
I'm facing some problems on the ldap filters for cucm 7.
What i want to do is apply this filter
(&(objectCategory=person)(objectClass=user)(telephoneNumber=*)(!(userAccountControl:1.2.840.113556.1.4.803:=65536))(!userAccountControl:1.2.840.113556.1.4.803:=2)(!(msExchHideFromAddressLists=TRUE)))
So will filter:
· Disabled accounts (Don’t want to see users that are disabled)
· Accounts without e-mail address (users without mail are usually service accounts)
· Accounts hidden from Exchange GAL (users hidden from GAL is usually some kind of system account)
· Accounts that has password set to not expire (users with that flag are usually some kind of system account)
ss Acconts that have the field telephone number blank
I have applied this but did not work, new users were not imported and existing users were flaged as active even though they do not exist on AD.
So move back to the original configuration:
v admin:run sql select ldap.name, ldf.tkldapserver as type, ldf.filter from ldapfilter as ldf inner join typeldapserver as ldap on ldf.tkldapserver = ldap.enum
name type filter
=========================================== ==== =============================================================================================
Microsoft Active Directory 1 (&(objectclass=user)(!(objectclass=Computer))(!userAccountControl:1.2.840.113556.1.4.803:=2))
Netscape or Sun ONE LDAP Server 2 (objectclass=inetOrgPerson)
OpenLDAP 3 (objectclass=inetOrgPerson)
Microsoft Active Directory Application Mode 4 (&(objectclass=user)(!(objectclass=Computer))(!(msDS-UserAccountDisabled=TRUE)))
But the problem persisted so i set up a trace, which give me this as output
ERROR [DSLDAPSyncImpl(f3e69f68-8645-2fd3-3321-68fa39717df6)] ldapplugable.DSLDAPSyncImpl (DSLDAPSyncImpl.java:917) - LDAPSync(f3e69f68-8645-2fd3-3321-68fa39717df6)[LDAPFullSync] javax.naming.directory.InvalidSearchFilterException: Unbalanced parenthesis; remaining name 'OU=Users,OU=Rio,OU=Brazil,OU=Energy Production,DC=NET,DC=FMCTI,DC=COM'
MESSAGE Unbalanced parenthesis
From TAC they said i have changed the filters and the is on that, but the filter is as it original state.
Hope someone has any clue, where the problem can be....
