November 14, 2022, 9:13pm
If a forum has had a social login provider installed for a long time and wants to remove it, what happens to the users who were using that provider? Will they still be able to login, for instance by receiving an email?
Is there a way to list all the users who were using a social login provider?
November 14, 2022, 9:17pm
If ‘local logins’ (i.e. username/password) logins are enabled, then they’ll be able to use the “reset password” button to receive a password-reset email and gain access to their account.
If you have other social login providers enabled, and users have the same email address on those services, then they can seamlessly login via another method.
This can be done using the data-explorer plugin:
Number of active users per login method
Counts how many users have used each login method in the last 28 days. The time period can be changed via a parameter
-- integer :last_seen_days = 28
SELECT provider_name, count(*)
FROM user_associated_accounts uaa
JOIN users u on u.id = uaa.user_id
WHERE u.active AND NOT u.staged
AND u.last_seen_at IS NOT NULL
AND last_used > NOW() - INTERVAL ':last_seen_days days'
GROUP BY provider_name
ORDER BY count(*) DESC
November 14, 2022, 9:20pm
Thanks so much! You rock!
December 14, 2022, 9:20pm
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.