I am trying to create a query I can run directly on the database to show what sites on a network are using a particular plugin. Do you know where the plugin info is stored that I could look at? Or even better, do you have a SQL query I could modify for my use that does something like this?
My database is overweight and I need to delete unused databases. I have over 4000 of them that needs to be checked for unused tables. I don't want to delete something I shouldn't be deleting and it's also hard to decipher each database by their name.