Multi site theme lookup list

Is there a plugin that generates a list of which theme is active on each subsite?

We have a multisite installation with over 400 active subsites and more than 50 active themes. The problem is that we need to deactivate some of the themes permanently and exchange them to a specific new one. But instead of going through each site individually, it would be great to just have WP make a list of active themes.

Anyone?