How to get user details of who's running workflow in Alteryx server

Jaimon_office

Hi Experts,

I would like to extract name of the person who's running the workflow on Alteryx server for one my projects. For this I tried the function, GetEnvironmentVariable("USERNAME") 

But this gave me just the remote desktop name while running from server and on local it gave me my name. So this didn't work for me.

Secondly I tried __cloud:UserId approach and it gave me so code which looked like a key. Is there any approach which could help me to extract the user name or email directly inside the workflow?

KGT

That __cloud:UserId is the GUID for the User in the MongoDB. Assuming you have default MongoDB under the hood on your server, you can use a MongoDB Input to pull the Users collection and match the ID to the user. When setting up the MongoDB for this, you will need the MongoDB admin password from the System Settings, otherwise you can ask IT to dump that collection to a DW table each week and hit it from there, but you then have your user table sitting somewhere else that needs to be protected.

The reason that the GetEnvironmentVariable did not work, is the user that it will be running under is a default one on the server unless you specifically have the workflow set up to run under user credentials (I don't recommend unless you need it, because it requires a lot more management). There is a difference between windows user and Alteryx user.