Return OU using SQL statement

[PawelTru]

I am trying to get the OU from AD using the following query:

SELECT * FROM OPENQUERY(ADSI,
'<LDAP://DC=test,DC=COM>;(&(objectCategory=Person)(objectClass=user)); ou, sAMAccountName, givenName, sn, name, PhysicalDeliveryOfficeName, homedirectory, telephoneNumber, department, mail,info, adspath;subtree')

The problem is that it returns null for all.

 

[tsuji]

>[tt](&(objectCategory=Person)(objectClass=user))[/tt]
Simply search for ou?
[tt](objectCategory=organizationalUnit)[/tt]
But looking at what attributes you try to return, maybe I misunderstand the question.