# Count number of Facebook logins?

**URL:** https://meta.discourse.org/t/count-number-of-facebook-logins/173082
**Category:** Support
**Created:** [December 12, 2020, 12:28pm UTC](https://meta.discourse.org/t/count-number-of-facebook-logins/173082 "2020-12-12T12:28:40Z")
**Posts on this page:** 1
**Showing post:** 2

<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: [December 12, 2020, 1:19pm UTC](https://meta.discourse.org/t/count-number-of-facebook-logins/173082/2 "2020-12-12T13:19:09Z")

</div>

This should help:

> [@Report number of users that have used each login method](https://meta.discourse.org/t/number-of-active-users-per-login-method/132943):
>
> 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 --[params] -- 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(\*) DESCplay_button Output

---

_[View the full topic](https://meta.discourse.org/t/count-number-of-facebook-logins/173082)._