Forum Discussion
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 UserPrincip...
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
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