We have now the Data Explorer plugin that allows us to run queries that would return what you are looking for (needs being a Discourse admin user, so e-mail addresses etc. are still protected this way).
This needs creating the queries once, which I can do (given a bit of time). When would you need this?