How to get the list of projects for specific issuetype in jira

[Nayana S]

For example:- 

There is a issue type called Epic, We need to get to know in how many projects is Epic issue type is added.

[Nic Brough -Adaptavist-]

Welcome to the Atlassian Community!

You can not directly do this, you will need to look at the list of issue types, note what schemes they are used in, and then go to the issue type schemes list to see what projects use them.

The issue type scheme list does list the issue types in the display though, so you could just start there, looking for "epic" in every line.

[Payne]

Here's something that may or may not work for you ... use JQL to view all issues for the issue type of interest, order by project, and include project in the displayed columns; then, just scroll down the list noting each time the project changes value. Perhaps limit the returned issues to just the ones created in the past year. i.e.

issuetype = Epic AND created > -365d ORDER BY project