How do I get the list of active (or idle users) in Jira ? I would like to get list of users who have not logged in, in the past 1 month, for example
Hi,
You can look at the table 'cwd_user_attributes' or 'userhistoryitem'
Cyrille
select count(*) from cwd_user where active = 1
Also as per this documentation, inactive user doesnt belong to any user groups. Since jira-users is basic group to which all users need to belong, you can query on that to get the list of active users too I guess.
select count(*) from cwd_group where group_name = 'jira-users'
Also programmatically, you may find this information:
For more details on definition of activeUser count, please read
Hope this helps,
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Not sure if there is any way you can get this information from API. Assuming you are using Jira out of box, you should be able to see last login, total number of logins in cwd_user_attributes table.
This may be an alternative if you are not able to find getting this data from API.
Raju
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.