We plemented different workflows and would like to have the ability to view the number of active tasks on each workflow and at the same time would like to be able to see who is working on those tasks. Right now we can see that under "Monitor Task window". The issue is that the workflow has over one thousand active instances and we want to be able to see the actual number of tasks, Activity name and what tasks are assigned to whom.
Can we run a SQL query to get this information and if yes what tables can we look at?