How to get list of Workflows that ran in the year 2020?

[Milant02]

Hi All,

We as server admin team are looking to find a list of the workflows that ran in the year 2020.

Could anyone please help where to start with or what tables to look upon?

We checked the database service layer however we could not find any such field which tells us which workflow ran at what time where we can filter out according to year 2020.

Help would be appreciated!

Milan Tanna

+91 8200235806

[raychase]

The AS_Queue collection within the AlteryxService db will contain this information. Some of the data may not be readily apparent as it resides in a ServiceData blob field. 

[seinchyiwoo]

Have you tried this Alteryx Server Usage Report?

http://downloads.alteryx.com/ServerUsageReport/AlteryxServerUsageReport.yxzp

It's tapping on MongoDB at the backend to obtain usage data including user activities, workflow/app runs, statuses etc

More about how to install and use the usage report: https://help.alteryx.com/current/server/install-server-usage-report 

-Seinchyi