I'm trying to create a report in Jira Service Desk using components but i'm not sure what the JQL expression would be or if it's even possible.
I want to report on how many issues we have based on components and export it into a csv.
Have you looked into 2 dimensional gadget provided by JIRA
You can map component vs issueTypes in above gadget.
Blaine, if you are simply wanting a table showing the number of issues by component and you plan to put eyes on it regularly then Taurn's recommendation is perfect IMO. Create a dashboard and add the 2D gadget. I would use component for Y-axis and Status for the X-axis. It would look like below with a total off to the right.
I would just select the contents of the page components page and paste it into excel or google sheets. It will likely format correctly and give you what you need. I don't think the report you're looking for will be created by Jira because all reports in Jira will count issues. I guess you could technically have an individual series for every component if you need it over time?
I am not sure if Service Desk is different, but in JIRA, I selected the components selection on the left nav to view the entire list (there were 100!) Highlighted the text, which included the component name and the component lead in the browser (chrome) and then pasted in excel. It worked surprisingly well.
There is no such JQL.
You can use gadgets. For example Issue statistics gadget
But you can not export it to Excel
Hello Atlassian Community! Feedback from customers like you has helped us shape and improve Jira Software. As Head of Product, Jira Software, I wanted to take this opportunity to share an update on...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events