Retrieving Confluence Analytics information directly from the Database

matthias_lutz

Hi all,

I was wondering if it is possible to retrieve the following data from the Confluence Analytics database as described here:

• count of unique users who have viewed a blog post
• number of likes for all comments of a blog post

The idea is to regularily pull this data to a PostgreSQL database for long-term analytics.

 

Thanks a lot in advance
Matthias

 

Marc -Devoteam-

Hi @matthias_lutz 

You can check the DB model of Confluence.

https://confluence.atlassian.com/doc/confluence-data-model-127369837.html 

But always be cautious when querying the DB, as a sinlge error can break the DB and bring your Jira down.

Better is to create a copy of the DB to query on.