Powerful Directory Management Tool

[jkinney]

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

[Support]

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.

[jkinney]

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

[Support]

Unfortunately this is not possible.

[jkinney]

Sounds like it might be a good enhancement request.