We have still unlimited JIRA license plan and want to know how many active users we have currently. I have been looking at this KB-article which is filtering users active=1 and where users are having membership. But in addition it also check schemepermissions which i don´t understand why. Can anyone confirm that this is relevant for this query?
The definition of active user counting in the license is that active=true and that he has permission to jira_users group.
Here is the SQL query:
SELECT DISTINCT u.lower_user_name FROM cwd_user u JOIN cwd_membership m ON u.id = m.child_id AND u.directory_id = m.directory_id JOIN schemepermissions sp ON Lower(m.parent_name) = Lower(sp.perm_parameter) JOIN cwd_directory d ON m.directory_id = d.id WHERE sp.permission IN ( '0', '1', '44' ) AND d.active = '1' AND u.active = '1';
In the Global permissions in JIRA see the groups which constitute top 3 permissions and then in the groups section of JIRA the number of users in those groups are basically the total active users. Mostly it's the jira-users group which has all the active user it's based on the global permission JIRA users in the global permission section.
Badges are a great way to show off community activity, whether you’re a newbie or a Champion.Learn more
A picture tells a thousand words. And agility boards have just released their latest feature: cover images on issues – so now your board can tell a story at first glance. Upload attachmen...
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG