How to find empty pages

[Khloe Salmon]

Hi all

I'm trying to do a major clean up and I keep coming across very old pages which are empty. I've found a page that shows me how I can bring up a list of when pages were last modified, but it doesn't seem to be able to differentiate if it's empty.

Has anyone been able to find a way around this?

Thank you!

Khloe

[Alexis Robert · Accepted solution]

Hi @Khloe Salmon , 

you could try using SQL queries for this, I think looking for pages with the smallest size should give interesting results. Using this page from the Confluence documentation, this query should return the 100 smallest pages in Confluence : 

SELECT s.spacekey, c.title, LENGTH(bc.body)
FROM BODYCONTENT bc
JOIN CONTENT c ON bc.contentid = c.contentid
JOIN SPACES s ON c.spaceid = s.spaceid
WHERE c.prevver IS NULL AND c.contenttype IN ('BLOGPOST','PAGE')
ORDER BY LENGTH(bc.body) ASC LIMIT 100; 

Let me know if this helps, 

--Alexis

[Khloe Salmon]

Thank you so much Alexis, this is perfect! :)