We need to have a report or dashboard which will tell us how many workflows are there on a portal, number of request against a workflow, recent transaction in a workflow n workflow created on. One can use the below query and get the result need to take in core.

SELECT COUNT(a.id),b.title,MAX(a.created_on) AS recent_transaction,b.created_on AS workflow_created_on

FROM #__workflow_transaction AS a

LEFT JOIN #__workflow_workflow AS b ON a.form_id=b.id

GROUP BY b.id;