Hi,

I need a SQL procedure to query the active directory and list the members details of a particular group. I am new to LDAP and any help would be
appreciated.

I've tested few scripts like the one below on Query Analyser to see how the whole thing works and it did work but it's not all the users that I need. I want to filter the search to members of a specific group.


SELECT sAMAccountName as [User Name]
FROM OpenQuery(ADSI,'SELECT displayName, sAMAccountName
FROM ''LDAP://192.168.0.1'' where objectClass = ''User''')

Thanks