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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.