The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

SQL Query to get commit count from DB

Mahalakshmi Sivasamy
August 7, 2020

Can you help me in getting a SQL Query to get the commit count?

2 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

1 vote
Answer accepted
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 Champions.
August 7, 2020

From what I can see, the database doesn't record that, the server just asks git what the count is when it needs it.

Christian Glockner
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 11, 2020

Nic is correct here - Bitbucket Server doesn't store commits in the database, so there is no query to retrieve this information from it.

Cheers,

Christian

Premier Support Engineer

Atlassian

0 votes
Uladzislava Kastsitsyna _Stiltsoft_
Atlassian Partner
April 26, 2024

Hi,

Consider taking a look at Awesome Graphs for Bitbucket. Our app enables you to export commit data on different levels via REST API or directly to a CSV file.

For example, here is how you can get a list of commits on a global level using REST API.

Hope that it helps.

Best regards,
Uladzislava

TAGS
AUG Leaders

Atlassian Community Events