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.