[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

Linked AD Server: Grab User Group(s

S.Arnwine

3/27/2007 11:13:00 PM

I've successfully linked Active Directory to my SQL Svr 2005. I now want to
query based on a user's name or id and return the group(s) they are
associated with.

I currently have a query such as: Select * from OpenQuery(ADLINK, 'Select
ADsPath, Name From ''LDAP://test.lab/OU=Users n Groups, dc=test,dc=lab''')

Which returns all the groups and members within the OU, I just want to see
the information for one specific member.

Thanks for your help!