Is there a way to do this? We are cleaning up some major spam and are wondering if there is a section that shows all posts / threads awaiting moderation. Otherwise you have to visit each and every thread to see if a post needs approved or not approved.
I see the user moderation queue, but that seems as if it is only linked to registrations.
The "moderation queue" link in the header (for moderators) is what you want. If you aren't seeing things there, then there's no content awaiting moderation. (If you are finding posts/threads awaiting moderation that aren't listed there, then there's a bug, add-on conflict, import issue or manual entry issue that didn't put them there.)