# How do I see Facebook signups?

**URL:** https://meta.discourse.org/t/how-do-i-see-facebook-signups/91989
**Category:** Support
**Created:** [7월 10, 2018, 2:59오후 UTC](https://meta.discourse.org/t/how-do-i-see-facebook-signups/91989 "2018-07-10T14:59:32Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Openmind](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/openmind/32/88333_2.png) [@Openmind](https://meta.discourse.org/u/Openmind)
#### Post date: [7월 10, 2018, 2:59오후 UTC](https://meta.discourse.org/t/how-do-i-see-facebook-signups/91989/1 "2018-07-10T14:59:33Z")

</div>

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

---

<div class="post-metadata">

### Author: ![david](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/david/32/157490_2.png) [@david](https://meta.discourse.org/u/david)
#### Post date: [7월 10, 2018, 3:08오후 UTC](https://meta.discourse.org/t/how-do-i-see-facebook-signups/91989/2 "2018-07-10T15:08:29Z")

</div>

You could use the [Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) 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:

```SQL
SELECT user_id from facebook_user_infos

```

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

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

```

---

<div class="post-metadata">

### Author: ![merefield](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/merefield/32/176214_2.png) [@merefield](https://meta.discourse.org/u/merefield)
#### Post date: [7월 10, 2018, 3:37오후 UTC](https://meta.discourse.org/t/how-do-i-see-facebook-signups/91989/3 "2018-07-10T15:37:21Z")

</div>

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

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [2월 5, 2021, 10:21오후 UTC](https://meta.discourse.org/t/how-do-i-see-facebook-signups/91989/4 "2021-02-05T22:21:58Z")

</div>