Hello Everybody,

I'm trying to create a SQL query to identify runaway or slow workflow (more than a hour running), until now I only saw this here on answers.

select count(a.task_id)
	, a.instance_id
	, a.activity_name
	, b.workflow_id
from workflow_task_queue_data a inner join search_instance b
  on a.instance_id = b.instance_id
  group by a.instance_id, a.activity_name,b.workflow_id

I don't know much about how the table structure is in workflow database, the only thing I need is

Workflow Status

Start Time

Workflow Name

if someone could point me where those values are I can create the sql query.

Thanks.

Amir