Request - Confluence Server SQL - Page Views

Question

Hello, could anyone direct me to the table which shows page view activity? DBO.CONTENT shows created, modified, and other user data, but I would like to pull page views.

* Bonus point if you supply the SQL statement if it involves a join.

Note: Global activity is enabled and I can see the top space page views and edits... so the data has to be captured somewhere...

Cheers!

Jonathan Smith · Answer

@Srinatha Tondihal I've installed that app in our DEV environment but the app's view counter only starts when the app is installed/enabled; I need to see the view count over the lifetime of the target page.

Is there no way to get the page view count from SQL? Even if the SQL for 'top 10 'most popular content (views)' (under space activity) could be supplied, I could simplify the query from there to a unique page.

Thanks,

Jonathan

Srinatha Tondihal · Answer

Hi @Jonathan Smith ,

You can use the page view tracker for that. Its a free app.

* Page-view-tracker

Thanks,

Srinath T

Jonathan Smith · Answer

@Srinatha Tondihal  I want to know how many times a page was viewed. Space activity shows the top 10 'most popular content (views)', but I want to be able to do this for any page.

Sorry, I didn't make that super clear in my question.

Thanks,

Jon