SQL-LDAP

General Discussion about LDAP Administrator

Moderator: Support

SQL-LDAP

Postby jkinney » Tue Apr 14, 2015 6:27 pm

Is it possible to use SQL-LDAP to do something of a relational query? My end goal is to query a group for all members, and then use those values to query an attribute from the user. The best example I can provide would be:

SELECT $member from "cn=GroupA,ou=groups,o=directory" WHERE $employeeID IS NULL

The query above only searches the group, but what I need is take the members that it retrieves & then query the user container to check if that user has the employeeID attribute populated or not.

Any assistance would be appreciated!


JK
jkinney
 
Posts: 7
Joined: Thu Feb 05, 2015 5:36 pm

Re: SQL-LDAP

Postby Support » Thu Apr 16, 2015 11:05 am

Hello,
You can try do another way. You can search using the memberof attribute:
Code: Select all
SELECT * FROM ROOTDSE  WHERE $memberOf='cn=GroupA,ou=groups,o=directory' AND $employeeID IS NULL

Instead of ROOTDSE you can use any base DN of the search.
Support
 
Posts: 886
Joined: Sun Aug 12, 2001 12:00 am

Re: SQL-LDAP

Postby jkinney » Fri Apr 17, 2015 10:10 am

I thought about that as well, which works by the way. However I would still like to know if it's possible to do a relational type query across containers or even possible between different data sources (i.e., - Match users between 2 different LDAP data sources based on a specific attribute).

Thanks for the response!


JK
jkinney
 
Posts: 7
Joined: Thu Feb 05, 2015 5:36 pm

Re: SQL-LDAP

Postby Support » Tue Apr 21, 2015 10:51 am

Unfortunately this is not possible.
Support
 
Posts: 886
Joined: Sun Aug 12, 2001 12:00 am

Re: SQL-LDAP

Postby jkinney » Tue Apr 21, 2015 10:54 am

Sounds like it might be a good enhancement request.
jkinney
 
Posts: 7
Joined: Thu Feb 05, 2015 5:36 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 1 guest