Retrieve OU (Organizational Unit) users from Active Directory LDAP Filter

[lanlizgu]

Hi,

I am trying to connect to the AD through the Organizational Unit (without success).

In Additional LDAP filter I can retrive correctly the users named Joe if I enter the following:

(givenName=*Joe*).

However, when I try to retrieve all the users of a specific OU (containing myou), I don't get any user

(ou=*myou*).

Any help?

Thank you

[Lauri]

I use this as my connection string:

(memberof=CN=qlik,OU=MyMembers,DC=mydc,DC=local)

I believe you need to specify the DC, in addition to the OU. In my case, I also specify the CN (security group named 'qlik').

[lanlizgu]

Thank you Lauri,

How can I know the CN?

If I connect to the LDAP through "OLEDB Provider for Microsoft Directory Services" filtering by a SAMAccountName I obtain the following ADsPath.

LDAP://xxxxxxx.es.xxxxx.net/CN=xxxxx,OU=Users,OU=Group,DC=es,DC=xxxx,DC=net

Obviously x are to avoid providing the real data. The thing is that the value inside CN= is the id of the user, not of a group.

I would like to connect directly filtering the data inside the OU. How can I do it?

[lanlizgu · Accepted solution]

Thank you Lauri,

At the end I have been able to read the LDAP. I created a Security group adding users on them and added the following syntax:

(memberof=CN=my security group name,OU=Groups,OU=Organizational Unit Name,DC=es,DC=companyname,DC=net)

However, Do you know if it is possible to read Organizational Units in order to avoid creating these security groups?

[Lauri]

Hi Lan,

Did you try:

(OU=Organizational Unit Name,DC=es,DC=companyname,DC=net)

You should be able to skip the CN.