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

[image] codinghorror: There may even be an answer here on meta already. 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?

[image] codinghorror: Kitchen sink topics are completely useless. 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.

SSO Users counts by provider

Product Support

simon November 7, 2019, 7:07pm 4

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

Topic		Replies	Views
Login type report / list? Product Support	4	635	June 14, 2023
Find all users who used "login with facebook" Data & reporting oauth2 , sql-query	5	1599	August 8, 2025
How to find all users using a specific login provider? Community Building	3	1455	September 2, 2019
Report number of users that have used each login method Data & reporting	1	1341	November 10, 2020
Reporting on Discourse app users Data & reporting	2	202	July 8, 2025

SSO Users counts by provider

Related topics