Getting user's full name from AD using username

[Vachaun22]

I'm having an issue getting the user's full name from AD using the logon name. I found this thread

http://www.tek-tips.com/viewthread.cfm?qid=463223

but it's erroring out giving me the Object not found on server error.

I checked the ldap string passed to GetObject and it is:

LDAP://CN=username,CN=Users,DC=domain,DC=local

where username = my username and domain = the domain name. It seems correct, but I get this:

Error: There is no such object on the server.

Which doesn't make sense. Could someone give me any suggestions? Thanks in advance.

 

[dm4ever]

Is the account you're trying located in the Users OU?
LDAP://CN=username,CN=Users,DC=domain,DC=local

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid

 

[Vachaun22]

Doh....

No, the account isn't in the Users OU. So that will completely backfire for me anyway because I won't know what OU the account exists in.

Back to square one now I guess.

I have a function that queries AD with the command:

"SELECT distinguishedName FROM 'LDAP://dc=domain,dc=local' " & _
        	"WHERE objectCategory='user' " & _
                "AND sAMAccountName='" & strUserName & "'"

Would the object returned here contain the full name?

 

[dm4ever]

You might try this

"SELECT cn, distinguishedName FROM 'LDAP://dc=domain,dc=local' " & _
"WHERE objectClass='user' " & _
"AND sAMAccountName='" & strUserName & "'"

and then just echo out the value for the "cn" field

--------------------------------------------------------------------------------
dm4ever
My philosophy: K.I.S.S - Keep It Simple Stupid