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- · Accepted solution]

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.