|
kdeutsch
Yak Posting Veteran
USA
75 Posts |
 Posted - 01/07/2013 : 15:31:32
|
trying to get the memebers from active directory groups, would liek to make it a Sp so i can call for multiple asp programs. What I have tried below returns mothing, i know group name is valid in AD.
select member from openquery(ADSI, 'select member
from ''LDAP://myLadp'' where memberOf = ''CN=NGMN Sec Readiness Admin'' and objectCategory=''Person''')
select *
from OpenQuery(ADSI,'SELECT objectCategory, samaccountname
FROM ''LDAP://myLadp'' WHERE objectClass=''group'' and memberOf = ''CN=NGMN Sec Readiness Admin'' ORDER BY cn') |
|
get member from AD Group
