The most edited page on the space in Confluence

[br00no1]

Hi everyone.

I need to find out how to get the most edited page on the space in Confluence (server). 
I've tried to use REST API but I've got no results.
Would you be so kind to help me, maybe you've got another ideas.

Thank you in advance.

Best Regards

[Daniel Eads]

Hi, welcome to the Community!

We have a SQL query documented that will help you out here. There's a short article about it in the Atlassian knowledgebase, but it will return the pages with the most number of edits sorted descending. We provide these in PostgreSQL, so you might need to make some syntax tweaks if your database is Microsoft SQL or Oracle.

select title,MAX(version) from content where contenttype = 'PAGE' group by title order by 2 desc limit 25;

Cheers,
Daniel

[Tarun Sapra]

Hello @br00no1 

I am not sure it's possible to get the kind of list of most edited pages which you are lookin' for out of the box.

There is a paid plugin which you can evaluate for this kind of reports

https://marketplace.atlassian.com/apps/1215795/analytics-for-confluence?hosting=server&tab=overview

[br00no1]

Hi @Tarun Sapra  thank you for your answer. 

Certainly i will check it.