LDAP query to retrieve members of a group

ldap

I know this question has been asked a few times already but I'm still at a loss 🙁

What I want to do is pass a security group name to an LDAP query and list out all the users who are a memberof. Am I right in understand that all that's required is to pass in the group's distinguished name, as follows? For some reason, the query is returning a blank.

(&(objectCategory=user)(memberOf={group distinguished name}))

Best Answer

Thanks for the replies. My query was correct! The reason I wasn't receiving users is that there weren't any in the security group - despite the fact that network admin claimed there were.

Related Solutions

LDAP: Is the memberOf/IsMemberOf attribute reliable for determining group membership: SunONE/ActiveDirectory / OpenLDAP

Will this approach using memberOf/IsMemberOf work?

It will work subject to the caveats.

Any caveats?

If it works the way the OpenLDAP implementation works, the memberOf attribute only works for entries made after it is enabled. It doesn't 'catch up'.

What about OpenLDAP or other servers? do they all support such an attribute. (I see that OpenLDAP has memberOf "overlay", but an

administrator must explicitly enable it)

You can interrogate the root DN of any LDAP server to find out whether it supports the feature. You are correct about OpenLDAP's support of this.

Sql – ID should not display between the specified date

For every row in Table1 we look for row in Table2 and show only rows with no Table2 match:



SELECT
  TABLE1.*
FROM TABLE1
LEFT JOIN TABLE2
ON 
  (TABLE1.ID = TABLE2.ID) AND --JOIN TABLE2 BY ID
  (TABLE1.DATE BETWEEN TABLE2.DATE1 AND TABLE2.DATE2) --AND BY DATE CRITERIA
WHERE 
  (TABLE2.ID IS NULL) AND --SHOW ONLY IF IT DIDN'T MATCH ROW IN TABLE2
  (TABLE1.DATE BETWEEN '21-02-2009' AND '26-02-2009')

Best Answer

Related Solutions

LDAP: Is the memberOf/IsMemberOf attribute reliable for determining group membership: SunONE/ActiveDirectory / OpenLDAP

Sql – ID should not display between the specified date

Related Topic