SQl query to find active users in bitbuucket

Akshay jain September 26, 2018

SQl query to find active users in bitbuucket

3 answers

1 vote
Uladzislava Kastsitsyna _Stiltsoft_
Atlassian Partner
June 1, 2023

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

0 votes
Akshay jain September 26, 2018

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

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 26, 2018

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 September 26, 2018

Thanks Nic.

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

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 26, 2018

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 September 27, 2018

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events