for reasons we want to discontinue that and would like to know the impact it would have on our user base. is there an easy way to find that out?

These Data Explorer queries can help in these cases. 1ª List of users per login with Facebook WITH target_user_ids AS ( SELECT id FROM users WHERE staged = false AND active = true AND last_seen_at IS NOT NULL) SELECT provider_name, user_id, info->>'name' name_user, info->>'email' email_user, info->>'image' image_user FROM user_associated_accounts ua WHERE user_id IN (SELECT id FROM target_user_ids) AND provider_name = 'facebook' provider_name user_id name email image facebook 1 User1 user1@gmail.com https://graph.facebook.com/.../photo1.jpg facebook 2 User2 user2@yahoo.com https://graph.facebook.com/.../photo2.jpg 2ª List of users per external login method discord facebook github google_oauth2 twitter WITH target_user_ids AS ( SELECT id FROM users WHERE staged = false AND active = true AND last_seen_at IS NOT NULL) SELECT provider_name, user_id, info->>'name' AS name, info->>'email' AS email, info->>'image' AS image FROM user_associated_accounts ua WHERE user_id IN (SELECT id FROM target_user_ids) provider_name user_id name email image google_oauth2 1 User1 user1@gmail.com https://lh3.googleusercontent.com/.../p1.jpg facebook 2 User2 user2@yahoo.com https://graph.facebook.com/.../p2.jpg twitter 3 User3 user3@gmail.com http://pbs.twimg.com/profile_img/.../p1.jpg 3ª Number of users per external login method WITH target_user_ids AS ( SELECT id FROM users WHERE staged = false AND active = true AND last_seen_at IS NOT NULL) SELECT provider_name, COUNT(user_id) AS qtd FROM user_associated_accounts ua WHERE user_id IN (SELECT id FROM target_user_ids) GROUP BY provider_name UNION SELECT 'github', COUNT(user_id) FROM github_user_infos WHERE user_id IN (SELECT id FROM target_user_ids) ORDER BY provider_name provider_name qtd discord 10 facebook 100 github 400 google_oauth2 500 twitter 200

There’s some discussion about this here [image] How do I see Facebook signups? Support Hi, is there any way to see who of my new forum sign-ups have used the Facebook login/sign-up plugin? Many thanks, Torsten

@david once your work consolidating is done, can you add a quick built-in report to data explorer that counts users per auth method. I think it can help make decisions in some cases.

Thank you for posting these queries! 2ª just answered a question I had. (Keyword boost: list oauth users, find oauth users, report of oauth users)

Find all users who used "login with facebook"

Community Building Data & reporting

david (David Taylor) December 31, 2018, 12:25am 4

Definitely . Once the new stuff is done we will also be able to report on “last used date”, which should be useful for deciding which methods are important.

Topic		Replies	Views
Count number of Facebook logins? Product Support	2	681	December 12, 2020
Login type report / list? Product Support	4	635	June 14, 2023
How to check how many users are using Facebook login? Product Support	1	854	September 28, 2018
How to find all users using a specific login provider? Community Building	3	1452	September 2, 2019
Is there a way of finding users who authenticated with Facebook? Product Support	1	631	December 17, 2020

Find all users who used "login with facebook"

Related topics