How to find the user who is connected to Database through Alteryx

Hi All,

From Alteryx I am connecting through SQL Server ODBC Data Source and writing data into SQL Server tables.

I have columns CREATED_BY and CREATED_DATE for each tables.

For CREATED_DATE i will use DateTimeNow() in the formula tool.

But for CREATED_BY, how can i get the user who is connecting and running the workflow to insert records in the database tables.

While using the output tool and connecting to SQL Server, I am giving the credentials to connect.

How can this user name be collected dynamically and inserted to the columns. Is it possible?

Please help me.

Thanks,

Preethi

Dynamic Processing

In Database

In-Database

Accepted answers

echuong1

You should be able to take advantage of environment variables to pull this in. You simply need a formula with the getenvironmentvariable() function. In the example below, I pulled in my username.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Reference-Windows-User-Paths-or-other-Environment/ta-p/35867

New Workflow1.yxmd

All comments

preethisisaac

Hi All,

Is there an automated way to get the IP ADDRESS of the machine.

Thanks,

echuong1

You should be able to take advantage of environment variables to pull this in. You simply need a formula with the getenvironmentvariable() function. In the example below, I pulled in my username.

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Reference-Windows-User-Paths-or-other-Environment/ta-p/35867

New Workflow1.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703