SSO Users counts by provider

AI-generated summary

The discussion revolves around gathering user counts by SSO provider in Discourse. jodyalbritton asks for a way to track how many users log in via different SSO providers, noting the lack of a built-in report. codinghorror references a previous answer and suggests creating a dedicated topic. simon confirms the information exists in a meta thread and moves the relevant query to a new topic in the #howto:admins category, tagging it with data-explorer. codinghorror emphasizes the need to avoid

Is there a way to gather information about the number of users coming in from different SSO providers? We are trying to get some insight into how our users are logging in. It appears there is a field on each user record for SSO but no report in the backend.

Yes, this question has come up before. There may even be an answer here on meta already. Can you assist @simon

There is. It’s here: https://meta.discourse.org/t/what-cool-data-explorer-queries-have-you-come-up-with/43516/169.

We need to break that out into its own topic. Kitchen sink topics are completely useless. Can you make it so?

Yes, they are. I had some trouble finding that query. I’ve moved it to its own topic in the #howto:admins category, and tagged it with data-explorer: Report number of users that have used each login method. I’m not sure this is the best way to classify these queries though.