How do I get a list of active components in JIRA and export them?

We are deprecating a development tool we use and moving to JIRA. I would like to be able to get a list of active components in JIRA to compare to our dev tools components to make sure JIRA is updated with all that we need. How do I get a list of the active components in JIRA and then export them to excel?

3 answers

2 accepted

getComponentList from JIRA Command Line Interface (CLI) produces a csv file that can be imported into Excel. Use with runFromProjectList to collect information from multiple projects into a single csv file.

Thank you Bob:)

1 vote
Answer accepted

I tried something a bit goofy but it worked surprisingly well for a simple list of components.

  1. Created a filter for "all the work in my group" (over 18K issues)
  2. Created a dashboard and added the Heat Map gadget
  3. In Heat Map gadget settings, Project/filter field = my "all work in group" filter and Statistic type field = Components
  4. Save gadget settings and you should see the heat map in your dashboard. 
  5. With your mouse, select all the components in the heat map list, then copy (control+C)
  6. Paste into MS Word. I got a bullet list, one bullet for each component
  7. Un-bullet the list, select all and copy, then paste into Excel (if that's where the list was going)

I was able to use the heat map gadget to create a list of labels as well.

Thanks Michelle! Appreciate the answer.

Like 1 person likes this

Thank you! It works! 

Hi Jana,

There is another easy and economic way of doing the same. you can run below JQL:

component is not EMPTY

Above will result in all the issues which are using the component, post which you can export the issue result in an excel and remove duplicates(data->remove duplicates), by this you will have a list of unique components currently in use.

If you want to list out all the components in JIRA Project, then you can simply navigate to the project->Overview->Components

It will list all the components which you can simply copy and paste in an excel. you will have the entire component list.

Hope this helps.

 

some extent it is ok, but what about if 500+ projects?

 

Thanks anyway.

Appreciate the answer but we too have A LOT of projects which makes it more difficult. But more importantly, I don't just want to see those that are being used, but those that are NOT as well so that we can remove them or question if they are still valid. It does however get me closer than I was when I posted this question:) Thanks for your time.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Mar 14, 2019 in Jira

Updates to jira.atlassian.com give you visibility into what's coming in Jira Server and Data Center

Hello, Community! My name is Gosia and I'm a Product Manager on Jira Server and Data Center here at Atlassian. Since 2002 when we launched our public issue tracker, jira.atlass...

635 views 1 15
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you