MongoDB Query

[Piyali417]

 I want to know which mongo db collection gives us exact report of - when is the gallery's  workflow's  last ran date?

Checked that  "AlteryxService" has a "As_queue" collection, but this collection shows records which is deleted also. 

How to get only current one report? 

Any reply will be appreciated.

[fmvizcaino]

Hi @Piyali417 ,

AS_Queue is the one you are looking for.

This collection will show all workflows that were executed inside your gallery.

If you want only the last execution date, you can summarize all workflows using the AS_Application_ID and merge with the AS_Application collection to get the workflow name.

You can also merge with the appInfos collection to find out which workflow has been deleted.

Best,

Fernando Vizcaino