How to generate the statistic of JIRA projects and issues quickly?

Question

Is there a way to quickly know how many projects and issues in JIRA?

The statistic should include the following information:

- List of projects (Fields: Project name, Project Lead)
- Numbers of projects assigned to specific Project Lead (Fields: Project Lead, project amount)
- Issue amount of specific project in each status (Fields: Project name, Backlog, Done,
In Progress, To Do)

I know there is [API][1] that can be used, do you have any suggestions?

[1]: https://docs.atlassian.com/software/jira/docs/api/REST/8.8.1/#api/2/issuetype-getIssueType

Earl McCutcheon · Accepted Answer

Hello @YJ Huang ,

Thanks for reaching out and just a note before I dig to deep into the explanations, as you noted this query is for Jira Server in the tags, just incase anyone else finds this thread looking for the same solution but are on Jira cloud platform I wanted to point out that the links below are specific to Jira Server but If you do find this and are on Jira Cloud make sure to referance the corresponding Jira Cloud API docs as the process will be similar however the endpoints will have slight variations between v2 and v3 rest on the two platforms.

Referencing the options you are looking for:

* List of projects (Fields: Project name, Project Lead)
* Numbers of projects assigned to specific Project Lead (Fields: Project Lead, project amount)
* Issue amount of specific project in each status (Fields: Project name, Backlog, Done,
In Progress, To Do)

First, I am using the Jira Server platform REST API documentation you noted in your description and again at the following link, which is specific to Jira version 8.8.1 as a referance point for the API calls noted below:

* https://docs.atlassian.com/software/jira/docs/api/REST/8.8.1/

To touch on item 1 and 2 in the list above there are a few location you would want to look You can use the REST API to get the list of all projects and the project lead via:

/rest/api/2/project?expand=lead

and you can get the fields via /rest/api/2/issue/createmeta expanding on the desired project key as described in the KB:

* https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-all-fields-in-a-project-967318426.html

Alternatively check out the following thread noting an option to do this using an add-on:

* https://community.atlassian.com/t5/Jira-questions/List-of-project-for-a-project-lead/qaq-p/348719

For item 3 getting an issue count, you can use a combination of JQL search terms to display the desired content and using the endpoint

/rest/api/2/search?jql=YOUR_JQL_QUERY

look at the resulting object and It will contain an attribute "total" which is the count of issues returned by the JQL.  Run the call on a loop one call per status to get the count of each, as an example if you are looking for the number of issues in project ASDF in status "To Do"  run a get on:

/rest/api/2/search?jql=project%20%3D%20ASDF%20AND%20status%20%3D%20"To%20Do"%20

The JQL could also be leveraged for the items above in 1 and two as well if you are looking for number of issues under a project lead you could use the JQL "project in projectsLeadByUser('username')" to get the total on everything under that lead.

and a full list of JQL search terms and the corresponding operations and functions can be found at:

* Advanced searching

Let me know if this clarifies the details you were looking for or if you have any additional questions.

Regards,
Earl