topic Get last run date for Workflows in Alteryx Server Discussions

Get last run date for Workflows

craigja — Wed, 18 Dec 2024 15:31:14 GMT

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?

Re: Get last run date for Workflows

fmvizcaino — Wed, 18 Dec 2024 21:48:39 GMT

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-schema-reference/alteryxservice-mongodb-schema.html#idp412069

Connect to MongoDB with ODBC

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

Best,

Fernando Vizcaino

Re: Get last run date for Workflows

craigja — Thu, 19 Dec 2024 08:41:30 GMT

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