Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP

How to get LDAP filters for Active Directory groups from users already in Qlik Sense

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Andre_Sostizzo
Digital Support
Digital Support

How to get LDAP filters for Active Directory groups from users already in Qlik Sense

Last Update:

Aug 24, 2020 7:10:27 AM

Updated By:

Sonja_Bauernfeind

Created date:

Feb 5, 2017 6:41:12 AM

Attachments

Figure out the correct LDAP filters for your Active Directory groups can be a hassle. With this script, you can get LDAP filters at ease after you synced your User directory connector (UDC) successfully.


LDAP filters are stored in UserAttributes table.


User-added image

Resolution:


Prerequisite:


1. Make sure that you, Qlik Sense administrator, is a member of your target Active Directory groups.
2. Make sure that you, Qlik Sense administrator, is an existing user in Qlik Sense. 
3. User directory connector (UDC) for Active Directory is created
4. The User Sync task for your UDC is Successfully synced

Instruction:


1. Download, unzip and run the script with PowerSchell (Right-click > Run with PowerShell)

2. Select the installation folder (e.g. C:\Program Files\Qlik\Sense) 


User-added image

3. Enter Repository password if needed. 


User-added image

4. Output <date>-<hostname>-GroupLDAPfilter.txt will be generated.

Tips:


Commonly used LDAP syntax for a filter is to "OR" 2 elements together with the "|" character (called the pipe character):


(|( element 1 )( element 2 ))

e.g.
(|( memberOf=<group 1> )( memberOf=<group 2> ))


Related Topic


How to Filter Active Directory to Sync Qlik Sense Users

Labels (1)
Contributors
Version history
Last update:
‎2020-08-24 07:10 AM
Updated by: