Is There a Way to identify how many issues are in the Link status's of a workflow prior to converting to a new workflow?

[JanaW]

I am converting many projects to a new workflow and want to work with the Project Leads to get their mapping from old to new prior to actually starting the conversion. Would like to get a sum of all issues that are in each existing step/linked status.

Icing on the cake if I could then export that out to an excel file.

[Udo Brand · Accepted solution]

You can do it by SQL:

SELECT COUNT(pkey) Status_Count,
issuestatus.pname 
FROM jiraissue, issuestatus
where issuestatus.id = jiraissue.issuestatus
group by issuestatus.pname