# ¿Informe/lista de tipos de inicio de sesión?

**URL:** <https://meta.discourse.org/t/login-type-report-list/268365>\
**Category:** Support\
**Created:** [14 Junio, 2023 21:07 UTC](https://meta.discourse.org/t/login-type-report-list/268365 "2023-06-14T21:07:22Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Lilly](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/lilly/32/575047_2.png) [@Lilly](https://meta.discourse.org/u/Lilly)\
**Post date:** [14 Junio, 2023 21:21 UTC](https://meta.discourse.org/t/login-type-report-list/268365/2 "2023-06-14T21:21:19Z")

</div>

creo que esto puede ayudarte

> [@Report number of users that have used each login method](https://meta.discourse.org/t/report-number-of-users-that-have-used-each-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/login-type-report-list/268365)._