How to query an email list of users that are not actived

Data & reporting
1

Hello,

I would like to have an email list of users who are not actived.
So I can send them a reminder.

I also suggest that Discourse have this feature:
Auto resend an activation email after x day, or have a bulk-resend in admin tools.

2

If you have the Data Explorer plugin installed on your site, you can get a list of users who have not responded to the activation email with the following query:

SELECT
u.id AS user_id,
email
FROM users u
JOIN user_emails ue
ON ue.user_id = u.id
WHERE u.active = false
3 Likes
3

I seem to remember this being implemented, with x = 1 day.

4

Since Discourse 2.3 a reminder (one reminder) will be sent to users who sign up but do not activate. This is completely automatic.

3 Likes
5

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.