Logged in Users

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.

Reporting

Tips and Tricks

Server

Accepted answers

gabrielvilella

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/35688

Ariharan

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

gabrielvilella

@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

All comments

gabrielvilella

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/35688

Ariharan

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

@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.

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167