Labels in total

just quick check with my dear community:  anyway to have labels in total assuming we have the database access ?  we want to know how many labels been generated ?

 

anyway to have labels in total assuming we are the jira admin (or even jira system admin)?  we want to know how many labels been used to attach onto issues? 

2 answers

One way is to see them into the issue on the field label if you just press the Label field there is a dropdown with all the available labels.

Just to make sure I understand your question, are you wanting to report on the number of labels per issue, or a complete list of labels in a jira instance?

complete list of existing labels in a jira instance (knowing we can have a label, but not use it)

complete list of active (used at least for one issue) labels in a jira instance. 

Thank you, @Todd Winton, I am doing some verification from one system to another, so at least jira ones I can get help here. 

by the way, I only know select * from label  , but I think there must be some other information I can get regarding label. 

If you have database level access, you can query the table [dbo].[label].  This will give you all of the labels and the issues they are associated with. 

I missed your comment about querying the table.  IN the column issue, that contains the id for the issue in the table [jiraissue] that you can link to to get the project and issue number.

thank you,  I used 

select count(issue), LABEL from label group by LABEL

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,264 views 14 20
Join discussion

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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot