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

[Aparanjith_DSG]

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]

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-Mongo...

AS_Queues: List of all previous executions - https://help.alteryx.com/20241/en/server/configure/database-management/mongodb-management/mongodb-sc...

AS_Schedules: List of all schedules - https://help.alteryx.com/20241/en/server/configure/database-management/mongodb-management/mongodb-sc...

Best,

Fernando Vizcaino