I have a WP multisite installation with a large number of sites. Thanks to auto-approving comments from registered users and invite only registration we no longer need to receive email notifications for comments pending moderation.
This is good and intended behaviour, but it has introduced a further issue. Some of the sites are accumulating large numbers of ‘pending’ comments, because its too much hassle for me to regularly visit each of the subsites specific admin page and manage their comments. Users could manage comments on their own sites, but most can’t be bothered.
I wouldn’t mind doing it if I had a central interface with which to bulk approve/mark as spam/delete selected pending comments from accross the entire multisite, but I don’t want to have to go into each sites admin screen.
Alternatively, list of all sites on the network, with their total pending comments and links to their comment admin page would suffice. At least then I wouldn’t waste time visiting the admin page of sites that don’t have pending comments.
Does anyone know of a plugin that can help with this? I’ve been searching and searching and can’t find anything that gets close to what I’m looking for.
I haven’t tried it. but this plugin looks like it satisfies your alternative option
http://wordpress.org/extend/plugins/mu-manage-comments-plugin/
However. the plugin warns that it might not be suitable for sites with large number of blogs – you may need to tune your PHP timeout value.
Since the plugin in the accepted answer is no longer available, I will provide you a solution to your alternative question:
The premium plugin Beyond Multisite, that I have developed, can show you such a list. To see it, after the plugin is activated:
Some benefits are: