AD name, what field

[stabben23]

Hi,

I have a connection to my Active Directory, where do I find the username for my user.

Lets say I have Joe Doe as username but I need JODOQV which is the name I us in Qlikview. Which field in which table?

[Gysbert_Wassenaar]

distinguishedName.

Download Rob Wunderlich's Qlikview Cookbook and look at the example in ADExtract folder.

[stabben23]

Hi Gysbert,

Ihave used Robs example and I use distinguishedName, but that will gives me the "wrong" username.

Maybe I have to use another table and the same field?

[Gysbert_Wassenaar]

Could be, perhaps you should ask this question on a forum with AD experts instead of one with Qlikview experts.

[stabben23]

But arent we expert on everything when we works with qlikview?

[Gysbert_Wassenaar]

I'm certainly not. And if you were, you wouldn't need to ask this question

[stabben23]

Me neighter, but we are surrounded by expert.

[stabben23]

sAMAccountName is the field that I was looking for.