How do I see Facebook signups?

[Openmind (Torsten Därr)]

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 (David Taylor)]

You could use the Data Explorer Plugin for this.

Associations with facebook accounts are stored in the `facebook_user_infos` table, so a query like this should provide a list of users that have connected their facebook accounts:

SELECT user_id from facebook_user_infos

Edit November 2020: data for facebook associations can now be found with the query

SELECT user_id, last_used FROM user_associated_accounts
WHERE provider_name = 'facebook'

[merefield (Robert)]

Well wadayaknow! Out of 3.5k users I have just one sign-up using Facebook?! That’s made my day!