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.
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:
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG