I'm wondering if there is way to find out how which themes are currently in-use within a single Moodle installation and how many courses are using each theme. Any help would be greatly appreciated.
Thanks!
Something like
SELECT theme, COUNT(*) FROM mdl_course GROUP BY theme;
might be a good start. I'm not aware of any UI that would display that.
David, surely you know about https://moodle.org/plugins/view.php?plugin=report_customsql
I do, thanks. I am also aware of https://moodle.org/plugins/view.php?plugin=local_adminer and couple of other tools that are able to display SQL query results via user interface (including command line interface) that one can choose from. What I meant was that AFAIK this particular "theme usage" report is not displayed to admins by the standard Moodle distribution itself.
Thank you for the responses, these are all great suggestions. I did read some about local_adminer but since it was just me who wanted to run the report, I just ran the sql command directly and it worked great.