topic Re: Logged in Users in Alteryx Server Discussions

Logged in Users

EN6924 — Wed, 09 Nov 2022 12:11:46 GMT

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.

Re: Logged in Users

gabrielvilella — Wed, 09 Nov 2022 15:21:20 GMT

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

Re: Logged in Users

Ariharan — Wed, 09 Nov 2022 21:38:17 GMT

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

Re: Logged in Users

EN6924 — Mon, 14 Nov 2022 10:41:55 GMT

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,

Re: Logged in Users

gabrielvilella — Mon, 14 Nov 2022 20:46:34 GMT

@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

Re: Logged in Users

EN6924 — Tue, 15 Nov 2022 04:58:47 GMT

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

Re: Logged in Users

EN6924 — Tue, 15 Nov 2022 05:24:46 GMT

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.

Re: Logged in Users

EN6924 — Wed, 16 Nov 2022 05:23:20 GMT

Issue resolved, adding a browse tool and output tool.

Re: Logged in Users

AijajShaikh_2023 — Sun, 21 May 2023 08:17:39 GMT

Hello,

Could you please share the workflow.