Comments
Sort by recent activity
So I guess this part of one of the procs being altered is the source of the problem:
-- get Active directory listing
insert #ADSI_USERS
select UserId = sAMAccountName
,UserAccount = cn
,FirstName = givenname
,LastName = sn
,Path = adspath
from OpenQuery
(LS_ADSI,'<LDAP://ourdomain.org>;(&(objectClass=user)(displayName=*)(givenName=*)(sn=*));
sAMAccountName,cn,givenname,sn,adspath')
Thanks for looking into it. / comments
So I guess this part of one of the procs being altered is the source of the problem:
-- get Active directory listing
insert #ADSI_USERS
select UserId = sAMAccountName
,UserAccount = cn...