Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
sorrakis01
Valued Contributor

Additional LDAP Filter works?

Hi,

I'm configurating an User Directory connectors by Active Directory. My LDAP has a lot of users and i'm using the Additional LDAP Filters but doesn't work.

CONNECTION: LDAP://XXXX.XX

ADDITIONAL LDAP FILTERS: (memberOf=xxxxx,CN=xxxxxx,OU=xxxxxx,,DC=xxxxxx,DC=xxx)

When  sync the connection Idle, external Fetch and stays at Database Store, and the log say this:

Retrieved 0 entities from directory

You are not allowed to deactivate the last root admin account

But if I connect and syncronize without ADDITIONAL LDAP It works

Any idea?

Thanks community

1 Solution

Accepted Solutions
sorrakis01
Valued Contributor

Re: Additional LDAP Filter works?

Hi,


Finally the problem was the userid.

For example:

  • all users named John: &(objectClass=user)(name=John*)
  • a specific user: &(objectClass=user)(sAMAccountName=userid)
  • more than one specific users: (&(objectCategory=person)(objectClass=user)(|(sAMAccountName=userid)(sAMAccountName=userid)))

Thanks

2 Replies
Employee
Employee

Re: Additional LDAP Filter works?

This indicates that the filter that you were trying to apply would've inactivated all the RootAdmin accounts so Qlik Sense opted to not fulfill the sync lest it lock you out of access Qlik Sense.

I'd check with your LDAP folks to make sure that the filter actually returns users on their end.

sorrakis01
Valued Contributor

Re: Additional LDAP Filter works?

Hi,


Finally the problem was the userid.

For example:

  • all users named John: &(objectClass=user)(name=John*)
  • a specific user: &(objectClass=user)(sAMAccountName=userid)
  • more than one specific users: (&(objectCategory=person)(objectClass=user)(|(sAMAccountName=userid)(sAMAccountName=userid)))

Thanks