This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Take a look at the Alteryx Server Usage Report. This report includes a bunch of summary-level information, but most importantly, it is an Alteryx workflow that has an embedded macro which queries the Alteryx Server back-end directly.
You should be able to isolate the information you are trying to get to (who runs workflows when) and build a process to automatically load this into another system at whatever frequency is required.
I would advise you grab this workflow, enter the credentials in the macro and then choose the tableau workbook option, by choosing this the d anchor will give you this merged table which we ourselves write to our own database for reporting, you can do the same.
Alternatively you could look inside the macro and grab the specific elements that are of interest to you.
Yes you can query it directly, there is a mongodb input tool in Alteryx.
But as mentioned, my advice would be to use the Alteryx server usage report macro, open it, and you can see all the different tables that Alteryx is querying and copy the relevant pieces out, for example the piece on Jobs.
You'll see within the macro there are about 6 mongodb inputs.