XF 1.5 Statistics of how many members have signed up with Facebook/Twitter/Google

[markku]

Is there a way (MySQL search is okay too if someone can give a command) to see the number of members who have signed up / associated their accounts with Facebook / Twitter / Google?

Thanks in advance!

 

[Fred.]

Good one! I would also like to have stats about that.

 

[Liam W]

Count of connections per provider:

SELECT provider, COUNT(*) AS count FROM xf_user_external_auth GROUP BY provider

Count of registered using external auth (and haven't set password manually):

SELECT provider, COUNT(*) AS count FROM xf_user_external_auth AS external INNER JOIN xf_user_authenticate AS internal ON (internal.user_id = external.user_id) WHERE internal.scheme_class = 'XenForo_Authentication_NoPassword' GROUP BY provider

Liam

 

[Mouth]

Is there a way (MySQL search is okay too if someone can give a command) to see the number of members who have signed up / associated their accounts with Facebook / Twitter / Google?

For another option; I created a usergroup called 'Social Linked' and then set a User Group Promotion for Apply This Promotion While ... user account is associated with their [social] account. Then whenever interested, just a Users Search for members of this UserGroup