nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Complete list of users showing their role profile and last logon details in Alteryx Server

EN6924

When I ran the 'The Alteryx Server Usage report', it has generated an excel file named - 'the session activity report' (Name of the user, Email and Session start time)

What I will have to do if I wanted to fetch the Complete list of users showing their role profile and last logon details in Alteryx Server?

Workflow

Tips and Tricks

Server

API

Accepted answers

MatthewO

@EN6924 there are a few options for obtaining this information. The Alteryx Server Usage Report queries the data from the MongoDB database. You could take the same approach using the MongoDB Input Tool. Alternatively, you could leverage the Server REST API to pull user details. The attached example uses the V3 API Macro Pack but it requires that you are running 2021.4 or later.

UserListAPI.yxmd

All comments

MatthewO

UserListAPI.yxmd

davidskaife

Hi @EN6924

You can leverage the Server APIs to obtain this information. How you go about it depends on what version you're running, the latest versions use V3 of the API and guidance on setting up etc can be found here - https://help.alteryx.com/20214/server/alteryx-server-api-v3

EN6924

Hi,

I'm not familiar with APIs

Could you please guide me how do I do these using MongoDB Input Tool

It's not showing any database and collection name to select.

EN6924

Hi,

I've found it -

esoden

Alteryx offers Workflow Admin Manager (WAM) as an add-on. It has prebuilt connections to MongoDB and most of the REST APIs. There are dozens of reports for usage, security, access, collections, subscriptions, data sources, runtimes, etc. It also helps with SDLC, governance, schedule maintenance, etc.

Tons of information here, including videos of most areas: https://capitalizeconsulting.com/workflow-admin-manager/

Quick Links

Popular Tags

This months top contributors

atcodedog05 19598

Qiu 15908

binu_acs 15783

MarqueeCrew 13709

apathetichell 13703