# Segnalazione / elenco tipo di accesso?
**URL:** https://meta.discourse.org/t/login-type-report-list/268365
**Category:** Support
**Created:** [14 Giugno 2023, 9:07pm UTC](https://meta.discourse.org/t/login-type-report-list/268365 "2023-06-14T21:07:22Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@rlauriston](https://meta.discourse.org/u/rlauriston)
#### Post date: [14 Giugno 2023, 9:07pm UTC](https://meta.discourse.org/t/login-type-report-list/268365/1 "2023-06-14T21:07:22Z")
Posso ottenere un report su quanti accessi di ciascun tipo (email, Google, Facebook) ha il mio sito?
Non sono sicuro che ci siano accessi tramite Facebook e, in caso contrario, vorrei disabilitare quella funzionalità.
---
### Author:  [@Lilly](https://meta.discourse.org/u/Lilly)
#### Post date: [14 Giugno 2023, 9:21pm UTC](https://meta.discourse.org/t/login-type-report-list/268365/2 "2023-06-14T21:21:19Z")
penso che questo possa aiutarti
> [@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
---
### Author:  [@rlauriston](https://meta.discourse.org/u/rlauriston)
#### Post date: [14 Giugno 2023, 9:41pm UTC](https://meta.discourse.org/t/login-type-report-list/268365/3 "2023-06-14T21:41:46Z")
Sembra perfetto, ma come eseguo una query?
---
### Author:  [@Lilly](https://meta.discourse.org/u/Lilly)
#### Post date: [14 Giugno 2023, 9:45pm UTC](https://meta.discourse.org/t/login-type-report-list/268365/4 "2023-06-14T21:45:39Z")
hai bisogno del plug-in [data explorer](https://meta.discourse.org/t/32566?silent=true).
> [@Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…
---
### Author:  [@rlauriston](https://meta.discourse.org/u/rlauriston)
#### Post date: [14 Giugno 2023, 9:50pm UTC](https://meta.discourse.org/t/login-type-report-list/268365/5 "2023-06-14T21:50:53Z")
Grazie! Quindi non abbiamo accessi a Facebook. Bene.