로그인 유형 보고서 / 목록?

[rlauriston (Robert Lauriston)]

이메일, Google, Facebook 등 각 로그인 유형별로 몇 건이 있는지 보고서를 받을 수 있을까요?

Facebook 로그인이 있는지 확실하지 않는데, 없다면 해당 기능을 비활성화하고 싶습니다.

[Lilly (Lillian)]

이것이 도움이 될 것 같습니다

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

[rlauriston (Robert Lauriston)]

디자인은 딱 좋네요. 그런데 쿼리는 어떻게 실행하나요?

[Lilly (Lillian)]

데이터 탐색기 플러그인이 필요합니다.

Discourse Data Explorer

Summary Discourse Data Explorer allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting. Install Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. 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 par…

[rlauriston (Robert Lauriston)]

고마워요! 그러면 페이스북 로그인이 없네요. 좋아요.