Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Get last run date for Workflows

craigja
9 - Comet

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?

2 REPLIES 2
fmvizcaino
17 - Castor
17 - Castor

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
9 - Comet

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