It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Bitbucket audit report

vowner vowner Nov 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
Ana Retamal Ortiz Atlassian Team Nov 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

vowner vowner Nov 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 Ortiz Atlassian Team Nov 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

0 votes
vowner vowner Nov 23, 2017 • edited

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

 

 

vowner vowner Nov 23, 2017

Any help here ?

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published in Bitbucket Pipelines

Building a Bitbucket Pipe as a casual coder

...ipe.sh :  #!/bin/bash source "$(dirname "$0")/common.sh" enable_debug extra_args="" if [[ "${DEBUG}" == "true" ]]; then extra_args="--verbose" fi # mandatory variables R...

3,045 views 1 20
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you