Forum Discussion

Darwood's avatar
Darwood
Frequent Visitor
4 years ago
Solved

Matching ActiveDirectory Username to UserPrincipalName

We have a SQL Database that stores the Active Directory (AD) username against transaction e.g. dwilliams. I have created a Dataflow that pulls our Users from AD but I can only see the the UserPrincipalName e.g. [email protected]. I don't know whether this is a limitation of the AD data connector or because we are in a hybrid AD environment. Is there any way that I can match these up or get the more basic username into the Dataflow?

Dataflow
Need Help
  • Darwood's avatar
    Darwood
    4 years ago

    Thanks Greg but I think USERNAME() only gives you the currently logged-in username. However my manager has found the information for me now in the expanded columns securityPrincipal.samAccountName and top.msDS-PrincipalName