列出所有具有特定电子邮件域名的用户

[Andro (Andrew Bernard)]

我无法将邮件发送给所有使用 Nederlands 域（.nl 后缀）的用户，这让我很难诊断。

如何获取具有给定域名的用户电子邮件列表，甚至是一个正则表达式？

[Lilly (Lillian Louis)]

您可以通过转到管理 - 活动用户列表 your-site/admin/users/list/active，然后在搜索过滤器中输入电子邮件域来完成此操作。

此外，这些主题可能对您有所帮助：

Troubleshooting Outgoing Email

This is an explanation guide discussing how admins can troubleshooting outgoing email from a Discourse site. Required user level: Administrator Discourse relies heavily on email for user notifications and account management tasks. If users are unable to receive emails from your Discourse site, this can lead to a variety of problems. Summary In this documentation, you will learn: How to check sent email logs Investigating skipped and bounced emails Common …

Troubleshoot email on a new Discourse install

You just installed Discourse via the install guide, but email doesn’t seem to work. Unfortunately this means you can’t log in as an admin to finalize the install. Let’s troubleshootize! Try the doctor If you run ./discourse-doctor it will check several ways that your mail configuration might be broken, and offer advice. Try that first. Did you enter email settings correctly? The simplest way is to run ./discourse-setup again. Did you enter everything correctly? B…

[Andro (Andrew Bernard)]

@Lilly 谢谢。我没说，但我确实在寻找一些通过查询 Rails 中的数据库或其他方式获取的报告。

[Andro (Andrew Bernard)]

@Lilly 谢谢。我们的邮件设置没有问题，是 Amazon SES 和 Nederlands 之间存在一个奇怪的问题，导致所有 Amazon SES 发出的邮件都被阻止和列入黑名单。这与 Discourse 无关——除了我希望能在错误日志中看到更多 SMTP 错误信息，它在错误即将开始的地方就截断了每个报告。我想知道如何查看完整的退信报告。[抱歉，我刚刚把这个话题带偏了，开启了一个新帖。]

[Lilly (Lillian Louis)]

您可以在 yoursite/admin/email/bounced 的“退回电子邮件报告”中查看它们。

或者，您可以使用数据浏览器查找某个域的所有用户，然后导出 CSV 文件。也许可以这样做：

-- [params]
-- text :domain = example.com


SELECT u.id AS user_id, u.username, ue.email
FROM users u
JOIN user_emails ue ON u.id = ue.user_id
WHERE ue.email LIKE '%' || :domain
  AND ue.primary = true
ORDER BY u.username

或者，您可以创建一个群组并自动将他们添加到该群组。