Common Components Report in Jira Service Desk?

[Matthew Swint]

I am trying to find how to report on the most common Components used in our Jira Service Desk deployment by our Service Desk agents. I can't seem to find anything to do this in the built-in reporting capability and can't find what links components to Jira Issues in the database other than having a Project in common.

Anyone know what the JQL query would look like that would spit out a list of, say the top 10 most common Components? I'd like to be able to pull this data from the database too as we are doing some external data analytics on our Jira Service Desk data and the database is all over the place with table relationships.

[Derek Fields]

You can see the top components on a Dashboard by using the Issue Statistics gadget. That is the easiest way. 

The SQL to get this from the database is

SELECT b.cname, count(a.component)
FROM jiraissue a
JOIN component b ON a.component = b.id
GROUP BY b.cname;

This will provide the same information as the Issue Statistics gadget. In this case, it does it for all projects. You can restrict it to a single project using the pkey field in the jiraissue table.