nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Sorin Sbarnea (

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.

Accepted answers

All comments

Geert_Graat

Hi,

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.

Regards,

Geert

Sorin Sbarnea (

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

Udo Brand

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.

Geert_Graat

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: https://confluence.atlassian.com/display/JIRAKB/How+to+Get+a+List+of+Active+Users+Counting+Towards+the+JIRA+License?focusedCommentId=394463339#comment-394463339.

Sorin Sbarnea (

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).

Udo Brand

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).

Joe Pitt

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration