cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
285
Views
0
Helpful
0
Replies

How to Check CUCM8.6 LDAP Filter from OS CLI

Guys,

In cucm 7.x you could run the command below to check the filter that is applied to your LDAP sync. 

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)

However when I use the same command on cucm 8.6, It returns the ff:

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

Column (tkldapserver) not found in any table in the query (or SLV is undefined) 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
Column (tkldapserver) not found in any table in the query (or SLV is undefined)

Can anyone let me know what command I can use to view the filter?

Please rate all useful posts

"'Nature is too thin a screen, the glory of the omnipresent God bursts through it everywhere"-Ralph Waldo Emerson       

Please rate all useful posts
0 REPLIES 0
Content for Community-Ad

Spotlight Awards 2021