How can I manage all multisite pending comments in one place?

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/

Conveniently shows a list of blogs with spam or unmoderated comments so that the Network Administrator can manage the the comments on network blogs. The list shows counts by blog with links to each comment.

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.