Get last run date for Workflows

[craigja]

I have been looking at tidying up our Alteryx server....  I have a list of the collections and the workflows inside them and can see the created date etc of the workflow, but would would be most useful would be a way to get the last run date.  That way I can contact designers who have workflows that have not been run in the past 18 months and check if they are still required.  Ive been looking through the API Docs and cant see a way to pass in a workflow ID and get the last run time, any ideas?

[fmvizcaino]

Hi @craigja ,

The easiest way is to connect to your MongoDB AlteryxService database and get this info from the AS_Queue collection.

AS_Queue collection

https://help.alteryx.com/20241/en/server/configure/database-management/mongodb-management/mongodb-sc...

Connect to MongoDB with ODBC

https://knowledge.alteryx.com/index/s/article/Set-up-an-ODBC-connection-to-query-your-embedded-Mongo...

Best,

Fernando Vizcaino

[craigja]

OK, not done that before!  Will read those docs and then might come back with more questions!