We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.
SOLVED

Logged in Users

EN6924
10 - Fireball
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.

8 REPLIES 8
gabrielvilella
14 - Magnetar

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
11 - Bolide

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
10 - Fireball

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
14 - Magnetar

@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
10 - Fireball

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.

 

EN6924_0-1668488032158.png

 

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
10 - Fireball

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

 

EN6924_0-1668489757997.png

 

EN6924_2-1668489798289.png

 

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
10 - Fireball

Issue resolved, adding a browse tool and output tool.

 

EN6924_0-1668576189563.png

 

AijajShaikh_2023
5 - Atom

Hello,

 

Could you please share the workflow.