Is there a way to create a report (possibly a SQL query) of the top X long running activities across all workflows? The result would be a list of activities that would normally show up when viewing the Activities tab in a Workflow instance and select 'Long-Running' from the filter, but it would be across all workflows instead of that specific instance. If there is a way to also get a total number of times they have run within a given amount of time, that would be great as well.

It would be nice if there was a report built into Workflow for this, similar to the Workflow Statistics Report, just for activities instead.