How to Query Alteryx Gallery Data

[rpaugh]

I'm looking to associated user information from the gallery with data they insert into a database, but so far have only been able to get User ID from Alteryx Desktop which is meaningless by itself.  How do I query the list of Alteryx users from the gallery to pull more meaningful information such as name and email address?

For example, here is what I have:

...and here is what I'm trying to get to:

Thanks in advance.

Rick

[NickJ · Accepted solution]

Hi Rick,

If you have access to the Server's persistence layer (i.e. the MongoDB database) then it's possible to connect to the AlteryxGallery database and the users collection to retrieve user information and tie this together with the ubiquitous UserId field found in your CreatedBy/ModifiedBy fields.

You can connect using a MongoDB Input tool (see: http://help.alteryx.com/10.6/index.htm#cshid=MongoInput.htm) but you will need the server database's user account credentials to retrieve what you're looking for. 

Regards,

Nick

[RodL]

Also there is an Alteryx Server Usage Report available at the Alteryx Download page.

You might be able to adapt what you need from there.