Query LDAP Groups - 04-18-2005 , 12:36 PM
I am wanting to create a sql query to get the Members of a Active Directory
group. I am using the below code:
SELECT * FROM OPENQUERY( ADSI,
'SELECT Name FROM ''LDAP://DC=DOMAIN,DC=com''
WHERE objectCategory = ''group'' and memberof = ''groupname''')
How ever this dose not work. What I need is basicly to search active
directory and get the logon name if the user is a member of a spacific domain
Any help would be really great.