SQL needed for space access by user

[Andy Boze]

I need to produce a report, for some arbitrary period of time and every space, who has accessed the space and how many times during the time period. Does anyone have any idea how I might do this? I'm relatively inexperienced with SQL and even less so with the Confluence schema.

We're running Confluence version 5.7.1 and MySQL 5.1.73.

Thanks!

[Nic Brough -Adaptavist-]

Confluence doesn't natively track "access" to spaces, so there's nothing stored you could even begin to query.

You'll need to look at one of the tracker add-ons you can get.

[Andy Boze]

Instead of user access to a space, would it be possible to get the number of page views per user for a space via a SQL query?

[AnnWorley]

Confluence doesn't write records to the database to track users accessing pages. There are user access logs you can turn on, but they won't look like a report.

Nic's suggestion of trying a tracking add-on is a good idea.

There are other ideas on this page:

How to Enable User Access Logging

[Nic Brough -Adaptavist-]

Please, re-read the first sentence of my answer.

[Andy Boze]

Sorry, when you wrote spaces, I didn't understand that to mean pages as well. Thanks for the assistance.

[Andy Boze]

Thanks, Ann. I'll take a look at the page.