List all groups and their current theme - 8.5

In version 8.5, is there a way to get a list of all the groups and what theme they are currently configured to use? I know we still have a few groups that are on the Enterprise theme and would like to make sure we convert them all to Social. I suspect it can't be done in the admin UI. How about a DB query?