Confluence Site/Space activity metrics

[Pranjal Shukla]

I'd like to know the SQL queries to get the details of the following:

• Most popular content (Views)
• Most active content (Edits)
• Most active contributors (Edits)
• Number of pages in a space
• Number of Edits/Page Creates in a space

[Jonas Andersson]

Thats quite a lot of work to nest queries that will do just this. If i were you, you could always install this plugin and enable mysql logging to see what queries the system would do itself to generate the same statistic:

https://marketplace.atlassian.com/plugins/com.atlassian.confluence.ext.usage/versions

[Pranjal Shukla]

Jonas, The plugin hasn't been updated for quite sometime and is not compatible with the version that we are on. Any other pointers?