Distributed Query Not Returning Any Results

[glewis1636]

I'm trying to get my users' e-mail addresses from active directory. after much distress and head pounding, I finally (at least apparently) have successfully created a linked server to my active directory. The problem is that I am getting no results from my query on users. Here is my code...

CREATE VIEW viewADContacts
AS
SELECT  [Name], sn [Last Name], street [Street], l [City], st [State], mail [E-mail]
FROM OPENQUERY( ADSI, 
     'SELECT name, sn, street, l, st, mail
      FROM ''LDAP://stexxxx/DC=soidom001,DC=local''
      WHERE objectcategory = ''person'' and
      objectClass = ''user''')
GO
SELECT * FROM viewADContacts

I'm 95% certain of the LDAP statement based on looking at the active directory. Any ideas on what else could cause me to get no results?

Thanks

 

[Luzian]

I don't know anything about active directory, but i know a little about SQL.

Either there are no records, or you're filtering them out. To check, eliminate the "WHERE" clause completely.

 

[Luzian]

try

CREATE VIEW viewADContacts
AS
SELECT  [Name],
	[sn] AS [Last Name],
	[street] AS [Street],
	[l] AS [City],
	[st] AS [State],
	[mail] AS [E-mail]
FROM OPENQUERY( ADSI,
     'SELECT name, sn, street, l, st, mail
      FROM ''LDAP://stexxxx/DC=soidom001,DC=local''')
GO
SELECT * FROM viewADContacts

 

[glewis1636]

I'm trying to get e-mail addresses from the users in Active Directory. I know that the object class of the users is 'user'. I had tried the query without adding the objectcategory to the where statement, and got the same results.
I also know that the active directory has records.

I guess it's back to the 5% doubt I have about the LDAP portion of my statement...

Thanks anyway, Luzian.

 

[glewis1636]

I got it!
The problem was with my login credentials... Once I got that sorted out, I got my results!!