Qlik Sense User Directory Connector - Additional LDAP Filter

[asmithids]

Hello,

I set up a User Directory Connector to Active Directory.  I need to filter the number of users synchronized to a specific Active Directory group.  I'm not sure what syntax I need to add to the Additional LDAP filter.  I checked the help guide for syntax examples, but it did not have usable examples. 

Does anyone have a document detailing how to script for Additional LDAP filtering or can offer the code I'll need to filter for a specific Active Directory group?

Thank you!! 

[sorrakis01]

Hi Alec,

Could you resolved this problem? I have problems with additional filter.

Thx

[lucienorrin]

Anyone? I am having issues also.

Thx

[sorrakis01 · Accepted solution]

Hi Luke,

I could resolve the  problem.

First in my case i don't need user and password for LDAP://server.com

Second don't enabled the check of Sync user data for existing users ...... (only first time)

after in additional LDAP filter use this structure:

(&(objectCategory=person)(objectClass=user)(|(sAMAccountName=xxxxxxxxx)(sAMAccountName=xxxxxx)))

Regards

[lucienorrin]

Thanks!

That worked great. I ended up having to take it a bit further and include users that belong to nested groups.

(&(objectClass=user)(memberof:1.2.840.113556.1.4.1941:=CN=mygroup,OU=Groups,DC=mydomain,DC=com))

Thanks again

[sorrakis01]

You are welcome Luke.

Regards