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

Community Building Data & reporting

AI-generated summary

Phuong_SuSu is seeking a way to obtain an email list of inactive users to send them reminders. simon suggests using the Data Explorer plugin with a SQL query to retrieve the list of inactive users:

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

Phuong_SuSu also proposes an auto resend feature for activation emails. riking thinks this might be implemented, and codinghorror confirms that since Discourse 2.3, a single automatic reminder is sent to users who sign up but do not activate.

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

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.