Logged in Users

[EN6924]

Dear Team,

How can I obtain information about the users who have been logged into Alteryx Designer and Alteryx Gallery over the past few months & what they have done (run/update/delete anything)?

Will I be able to obtain this information if I run Alteryx Server Usage Report?

Kindly help.

[gabrielvilella · Accepted solution]

Hi @EN6924, yes, the Usage Report provides insight on the activity of the users. You can learn more about this report here:

https://community.alteryx.com/t5/Engine-Works/Alteryx-Server-Usage-Monitoring-amp-Reporting/ba-p/356... 

[Ariharan · Accepted solution]

Hi @EN6924 , 

Alteryx MongoDB only contains limited field audit information such as update, delete, replace.

Please refer the below document for your reference, 

https://help.alteryx.com/developer-help/auditlog-endpoint

Regards, 

Ariharan R

[EN6924]

The Alteryx Server Usage report is showing - the session activity report (Name, Email and Session start time) starting from a selected period of days.

What I will have to do if I wanted to fetch the complete list of users showing their role profile and last logon?

Please assist,

[gabrielvilella · Accepted solution]

@EN6924 if you need more information that is not already on the Usage Report, you might need to query the MongoDB directly. Here is the documentation on what you can expect to find it there.

https://help.alteryx.com/20212/server/mongodb-schema-reference 

There is a collection called users under the AlteryxGallery schema. There you can find the LastLoginDate.

https://help.alteryx.com/20212/server/alteryxgallery-mongodb-schema 

[EN6924]

Using MongoDB Input Tool, I have created a simple workflow which will display the complete usernames, their roles and last logon information exactly what I required.

Now I'll have to upload it on the Alteryx Gallery.

The workflow must be modified so that users can select a date range and generate the result on their own. I believe that adding an interface tool and turning it into an analytics app can accomplish this. But now that I know how to accomplish it, could you kindly provide guidance like where to add it (After which tool).

[EN6924]

It's not working this way, every time showing no output files generated

Filtering the last logon date, so that users can fetch last logon users for a selected date range. I can't share the app sorry for that, Kindly help.

[EN6924]

Issue resolved, adding a browse tool and output tool.

[AijajShaikh_2023]

Hello,

Could you please share the workflow.