Workflows Metadata Info

[SSorianoA]

Hi Alteryx Community,

I am trying to retrieve all the information about the workflows created in Gallery. I tried using the API of the workflows but I need the field of the last date that the workflows have been run. 

Where can I find this data? Any tip?

Thank you all! 😃

[chukleswk]

This can be found in the AlteryxService.AS_Queue collection under CreationDateTime field.

• AlteryxService MongoDB Schema 
  
  • The AS_Queue Collection contains queued jobs. Both currently waiting and completed jobs are present in the queue. The corresponding AS_Queue.Files Collection is used if the document exceeds MongoDB's max document size

[SSorianoA]

Thanks for your help. The workflows that you mentioned are those that are scheduled to be run and that works for me. But is also possible to retrieve the information for those that are not scheduled?

Thx!!