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 Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

688 views 6 13
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