How to find active users count/ list in Jira, Bitbucket and Confluence

[Ravindra Ravindra]

Hello,

I need to find the active users in my Jira, Bitbucket and Confluence instances for last 90 days duration.

Can anyone please help me with sql queries for all 3 applications or if is there any other way like API or something, please suggest.

Thanks

[Fadoua · Accepted solution]

@Ravindra Ravindra 

https://confluence.atlassian.com/jirakb/identify-users-in-jira-who-haven-t-logged-in-for-the-past-90-days-695241569.html

[Fadoua]

Do you grant access to users to some tools but not others? Or once they have a access to a tool then it applies to the others as well?

[Ravindra Ravindra]

@Fadoua Its a normal user who login to these applications.

[Ravindra Ravindra]

@Fadoua Can you share the same procedure for Bitbucket and confluence as well?

[Fadoua]

@Ravindra Ravindra

Confluence:

https://confluence.atlassian.com/confkb/how-to-identify-inactive-users-in-confluence-214335880.html

BiBucket

https://confluence.atlassian.com/bitbucketserverkb/query-for-inactive-or-idle-users-779171719.html

Best,

Fadoua

[Ravindra Ravindra]

@Fadoua Thank you so much for your help.

[Fadoua]

If satisfied with the help provided @Ravindra Ravindra please don't forget to accept my answer.

Best,

Fadoua

[Ravindra Ravindra]

@Fadoua Done, thanks