Hello,
I want to create a Tableau Dashboard to check which the jobs were running on the server every day.
To feed data to the Dashboard, I created a workflow to collect data on the server MongoDB,
which is scheduled at midnight to get the data for the previous day.
I use "AS_Queue" collection of "AlteryxService" Database to get
[AppName], [Creation Date Time], [Completion Date Time], [Status], [AS_Application__ID], [SubscriptionId].
After adding [email] and [workflow name] from other collections, I fed the data to Tableau to visualize.
The Dashboard shows the data as below.
As you see, 10 jobs were created at around 5:00 AM, but they all waited for the completion of an earlier job.
From this result, I guess the [Creation Date Time] is actually the en-queued time (when a job was add to the job queue),
not the job-start time (when the job was passed to the worker for execution).
I want to know which jobs were running on the Workers at a specific time, but
I guess [Creation Date Time] does not serve for this purpose.
I looked at the MongoDB Schema document, but could not find the field to serve for the purpose.
Could you advise where I should look at to get the above data?
( I am thinking of parsing the Engine Logs, but I would prefer getting the data from MongoDB. )
Thank you,
