How to get extract page hits,users for all pages in a particular space from confluence db ?

[Komail Badami]

I need to get historical data from my confluence installation say 6 months earlier. I have access to the confluence mysql db, but can't seem to know which table has the required information, I am not even sure if the information i want is actually stored in the db. Is there anyway I can retrieve this data ?

[Nic Brough -Adaptavist-]

Have you enabled the Confluence statistics add-on (it's off by default as it can cause performance issues), or used a 3rd party add-on for the tracking?

[Komail Badami]

I forgot to add that I don't have the confluence statistics add-on enabled or have a 3rd party add-on for tracking. Is it possible to merely query the db and get the data I want ?

[Nic Brough -Adaptavist-]

What data?  You haven't enabled any tracking, so there's nothing tracked.