nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Bitbucket audit report

vivuu

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

Accepted answers

All comments

Ana Retamal

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

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

vivuu

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

Any help here ?

Ana Retamal

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

Ravi GH

Follow this link https://confluence.atlassian.com/bitbucketserverkb/how-to-report-on-permissions-by-querying-the-database-858696596.html