FAQ: How do I query Active Directory from SQL Server?

More Thoughts on ADAM

Virtual Identity Dialogue — Thu, 08 May 2008 00:35:02 GMT

So James has responded back to me on ADAM.

Euan Garden — Tue, 05 Jun 2007 07:28:57 GMT

Yep thats simpler but by default is it not subject to the 1000 row limit I mentioned?

Manges — Tue, 05 Jun 2007 06:07:11 GMT

--A little easier way to perform this :-)

--Create the linked server

EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5',

'ADSDSOObject', 'adsdatasource'

--Create the login account

--(change SQL_ACCOUNT_NAME, --NT_ACCOUNT_NAME, PASSSWORD)

EXEC sp_addlinkedsrvlogin 'ADSI', False, 'SQL_ACCOUNT_NAME',

'NT_ACCOUNT_NAME', 'PASSWORD'

--Execute your query

SELECT samAccountName, givenName [First Name], sn [Last Name],

legacyExchangeDN

FROM OPENQUERY(ADSI,

'SELECT samAccountName,

givenName, sn, legacyExchangeDN

FROM ''LDAP://DC=zm,DC=COM''

WHERE objectClass=''Person''

AND objectClass = ''User''')

WHERE givenName IS NOT NULL

Active Directory Tool » FAQ: How do I query Active Directory from SQL Server? — Sat, 31 Mar 2007 11:17:42 GMT