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

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 : 

 

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

 

Let me know if this helps, 

 

--Alexis