Login type report / list?

[rlauriston (Robert Lauriston)]

Can I get a report of how many logins of each type (email, Google, Facebook) my site has?

I’m not sure there are any Facebook logins, and if not I’d like to disable that feature.

[Lilly]

i think this may help you

Report number of users that have used each login method

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(*) DESC

Output

<a class="lightb…

[rlauriston (Robert Lauriston)]

Looks on point, but how do I run a query?

[Lilly]

you need the data explorer plug-in.

Discourse Data Explorer Plugin

Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Repository Link https://github.com/discourse/discourse-data-explorer Install Guide How to install plugins in Discourse 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 t…

[rlauriston (Robert Lauriston)]

Thanks! So we have no Facebook logins. Good.