A WP-CLI command to list all sites in a Multisite network that have activated a given plugin. Based on Ian Dunns great work.
wp package install hive-it-gmbh/wp-cli-plugin-active-on-sites
wp plugin active-on-sites <plugin_slug>
[--field=] Prints the value of a single field for each site. [--fields=] Comma-separated list of fields to show. [--format=] Render output in a particular format.
> wp plugin active-on-sites eu-cookie-law-widget
+---------+----------------------------------------+
| blog_id | url |
+---------+----------------------------------------+
| 320 | http://2014.madrid.wordcamp.dev/ |
| 371 | http://2014.paris.wordcamp.dev/ |
| 413 | http://2015.london.wordcamp.dev/ |
| 464 | http://2015.milano.wordcamp.dev/ |
| 522 | http://2016.geneva.wordcamp.dev/ |
| 571 | http://2016.belfast.wordcamp.dev/ |
| 654 | http://2017.europe.wordcamp.dev/ |
+---------+----------------------------------------+