How can I get a list of plugins and which blogs are using them?

Question

I'm about to upgrade my Wordpress MU installation to wordpress 3

Before I update, I want to find out which blogs use which plugins.

I don't see a way to do that in the UI, is there?

What about a query of the mysql database?

Thanks

Answer 1

take a look at Plugin Commander which is a plugin management plugin for multi-site mode, which allows further control on network-activated plugins.

Answer 2

I was having trouble with Plugin Commander with version 3.4.1 but WPMU Plugin Stats seems to be working pretty well even though it has not been updated in 2 years.