SQl query to find active users in bitbuucket

[Akshay jain]

SQl query to find active users in bitbuucket

[Uladzislava Kastsitsyna _Stiltsoft_]

Hi,

In case you are willing to consider alternative solutions, you can check out Awesome Graphs for Bitbucket. This app provides an array of reports on both individual user commit and pull request activity and the activity of the whole team. 

This report focused on side-to-side recent activity and might be of particular interest to you. 

Hope that helps,

Vlada

[Akshay jain]

I need sql query to run on database to find out active user count on bitbucket

[Nic Brough -Adaptavist-]

You'll need to define "active" and then work out how to measure it.  Once you've done that, we might be able to help you with some SQL, but only if your measurement is something Bitbucket actually records in the database.

[Akshay jain]

Thanks Nic.

Any idea about the count of active users in Bamboo. How I can find out?

[Nic Brough -Adaptavist-]

Pretty much the same - define what you think of as "active" and have a look at the user page or build some sql

[Akshay jain]

But in below link it tells there is no active user limit in bamboo.

https://community.atlassian.com/t5/Answers-Developer-Questions/Get-amount-of-active-users/qaq-p/493422

[amit raj]

please go through this document-

https://confluence.atlassian.com/jirakb/how-to-get-a-list-of-active-users-counting-towards-the-jira-application-license-278695452.html

https://confluence.atlassian.com/bitbucketserverkb/how-do-i-find-which-users-count-against-my-bitbucket-server-license-779171685.html