Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sorrakis01
Specialist
Specialist

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
Specialist
Specialist
Author

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

View solution in original post

2 Replies
Levi_Turner
Employee
Employee

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
Specialist
Specialist
Author

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