How do I find empty pages?

[Saira]

Is there a way via confluence automation/cql to find pages that have no content? 

[Aron Gombas _Midori_]

You can access the "Text" field in CQL but it is also affected by the page title (and others), so it cannot be used to test the emptiness of the body only. I don't know maybe you could rethink your condition and test if the "Text" field is less than N chars long...

Or, our Better Content Archiving can be used to detect unused pages by tracking the last views and last updates on them. Any of those, or even combining them, could be a better signal of unused pages that are candidates for archiving.