No of Records processed in Alteryx Workflow

[Naren86]

Hi Team, I'm looking for a solution to fetch the no of records [source/target] processed by Alteryx workflow for historical date or a month back data, hence I would need to understand if Alteryx stores he no of records [source/target] processed in job somewhere in metadata ?

[TimN]

Hi,

Every Alteryx execution generates a log file.  The log file will contain details on inputs and outputs including the number of records.  If you are talking about workflows on the server, you can look at logs there as well or what information is kept in the MongoDb (similar to log file data).

[Naren86]

Thank you @TimN for the reply , I can get those data on log file, however is the similar log file data is stored anywhere in the Mongo DB ?

[TimN · Accepted solution]

Hi,

Yes, similar data is stored in Mongo and can be accessed using alteryx apis or query against MongoDb.  Api use would require Curator access and Mongo would require logon details from your admin.  

I'm on 2021.4 - this api - GET /admin/v1/workflows/jobs/ can return the log data.

[Naren86]

Thank you @TimN for your help, I was able to get what I wanted via API v1 😀 however, do you know which table in mongo DB has this information , just to have this information handy.

[TimN]

Hi,

The version you are on may have changes to Mongodb schemas but try here.

https://help.alteryx.com/current/en/server/configure/mongodb-management/mongodb-schema-reference.htm...

Tim

[TimN]

It's in the "As_Results".  The release I'm on 2021.4 stores the log in a blob.  

https://community.alteryx.com/t5/Alteryx-Server-Discussions/Message-Tool-In-Server-Pull-for-Usage-Re...

[Naren86]

Thank you @TimN 😀