How can I see the number of users counting towards the license on JIRA?

How can I see the number of users counting towards the license on JIRA?

I do mention that I do have an Unlimited user license on this instance but because of the huge spike on the pricing made by Atlassian we do want to downgrade to a lower number.

So far I was unable to find the current number of users.

Please note that disabled users are not counted so the size of jira-users group is not a correct measure.

3 answers

This widget could not be displayed.


In the administration section, under System > License, you see an overview of your current license including the limit and the total number of active users.



This is where I looked and there is no number there. User Limit: Unlimited

Hm, I assumed that it would display the number of active users as it does in my case, but that only seems to apply to limited licenses. You can query your database as described in a KB article, but before you do that, you might want to try this suggestion in the comments of the same article:

This widget could not be displayed.

You can query on the database

select count(*) from cwd_user where active = 1

 I believe the active user have active = 1 but I'm not 100% sure.

The query if far from being correct, it will count disabled user directories too, count users in multiple directories twice and also will count people that could logon to JIRA but never did (which are not members of jira-users yet).

Ah, correct. should be "count (distinct lower_user_name)" for those users set up in different directories. Since I never had disabled directories the query was correct for me. So please use the query as described in KB article mentioned by Geert. Users that are set up but did not login however count towards the user license, as far as I know. And to be precise you would need to substract 1 (for the admin account which does not count towards the license).

This widget could not be displayed.
Joe Pitt Community Champion Sep 30, 2014

All userids in any group with logon rights (jira-users by default) count toward the license.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

285 views 5 0
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