Bitbucket audit report

vivuu November 22, 2017


We need to provide a audit report to the mangement on who has accessed the Atlassian tools - Bitbucket,  in the last 30 days ?

 

2 answers

0 votes
vivuu November 23, 2017

Can we get this done by using DB query ?

We are using MSSQL and Can you share us the query to achieve that.

DBname - Bitbucket

 

Bitbucket version - 4.9.1

 

 

vivuu November 23, 2017

Any help here ?

0 votes
Ana Retamal
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 23, 2017

Hi! If you're in Cloud you can see the Audit log by clicking on your avatar > Bitbucket settings > Audit log. You won't be able to filter so you'll see all the activity that happened into the account.

If you're using Bitbucket Server, you can get a different kind of audit. You can read more about it at Audit logging in Bitbucket Server.

Hope that helps!

Ana

vivuu November 23, 2017

Can we get this done by using DB query ?

We are using MSSQL and Can you share us the query to achieve that.

DBnames


Bitbucket

Ana Retamal
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
November 28, 2017

Hi Vivuu, you can find some SQL examples in the article Query for inactive or idle users. You can find MySQL, Postgres and Oracle, Transact SQL (the variant that MSSQL uses) is not included but maybe you can work around the previous ones.

As for the query you're asking for, I'm afraid I'm not familiar with the variant of SQL that Microsoft uses. Hopefully some other user will be able to help you with that :)

Best regards!

Ana

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events