How to pull all jobs/workflows running on server with status (failed/success)

Question

Hi,

I am the Alteryx admin, and I need to pull the Alteryx report to see all the scheduled jobs that ran on the server for that day with the status (failed/success). Is there any pre-build workflow which can pull this report?

Can someone please suggest?

fmvizcaino · Answer

Hi @Aparanjith_DSG ,

We used to have the Alteryx Server Usage Report that had this as part of the dashboard and the mongoDB extraction. (It is currently deprecated but they are releasing it once again on 25.1)

Until them, you can connect to your MongoDB and build this report.

How to connect to your MongoDB: https://knowledge.alteryx.com/index/s/article/Set-up-an-ODBC-connection-to-query-your-embedded-MongoDB-in-Version-20231

AS_Queues: List of all previous executions - https://help.alteryx.com/20241/en/server/configure/database-management/mongodb-management/mongodb-schema-reference/alteryxservice-mongodb-schema.html#idp413217

AS_Schedules: List of all schedules - https://help.alteryx.com/20241/en/server/configure/database-management/mongodb-management/mongodb-schema-reference/alteryxservice-mongodb-schema.html#idp413446

Best,

Fernando Vizcaino