Thanks for trying my plugin. I pulled the database query out of the plugin to post it here, and you could run this on your database if your table prefixes are the default wp_.
SELECT wp_users.ID, wp_posts.ID AS post_ID
FROM wp_users
LEFT JOIN wp_posts ON wp_users.ID = wp_posts.post_author
WHERE wp_posts.post_title <> 'Auto Draft'
AND wp_posts.post_type = 'post'
ORDER BY post_date DESC
LIMIT 30
This finds all the recent posts with the exception of Auto Drafts. This will include posts that are not spam. The plugin does not detect spam, it simply spits out the authors of the latest posts or drafts and allows you to choose which ones are spam.
If you see nothing in the list, I wonder how your installation is different from mine. Are your posts being created with a post_type of post? Are the submitters of items to your site real users that are in the wp_users table?
