Confluence audit report


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



2 answers

0 vote
Ann Worley Atlassian Team Nov 22, 2017

Confluence doesn't have any reporting built in that would provide  historical access information. If you have a proxy in front of Confluence, the proxy logs may have recorded access history.

Going forward, you could use user access logging to see which users accessed which URLs over a period of time. Please see: How do I get more statistics from Confluence?:

Confluence has a built-in access logging mechanism, which shows who has logged in and the URL invoked. To enable it, you need to modify a couple of configuration files and restart Confluence. The traditionally generated access log can then be analysed by one of the available access log analyser tools such as Webalizer, Google Analytics or AwStats which can generate useful statistics.

The page linked above also has some SQL queries and recommendations for plugins that could be useful.

Can we get this done by using DB query ?

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

 

Confluence_DB

Can we get this done by using DB query ?

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

 

Confluence_DB

 

Confluence version - 5.10.0

This data is not held in the database.  Please have a look at the link Ann gave you.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

375 views 20 10
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you