Hello,
I new to above concept.I want all domain users name ,Please give me idea or solution
What I have tried:
I have Active directory's openQuery concept like****'****'****'****'****'****'
GO
EXEC master.dbo.sp_addlinkedserver @server = N'ADSI_12', @srvproduct=N'Active Directory Service Interfaces', @provider=N'ADSDSOObject', @datasrc=N'adsdatasource'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'ADSI_12',@useself=N'False',@locallogin=NULL,@rmtuser=N'JKMARLOCAL\SUJATA.SHINDE',@rmtpassword='*********'
and select command like
SELECT * FROM OpenQuery (
ADSI_12,
'SELECT displayName, telephoneNumber, mail, mobile, facsimileTelephoneNumber
FROM ''LDAP://JKUMARLOCAL.com,DC=JKUMARLOCAL,DC=com''
WHERE objectClass = ''SUJATA.SHINDE''
') AS tblADSI
order BY displayname
but i does not meet my requirment