# How to pull all valid email address from console in my server?

**URL:** <https://meta.discourse.org/t/how-to-pull-all-valid-email-address-from-console-in-my-server/50657>\
**Category:** Support\
**Created:** [2016年九月26日 03:55 UTC](https://meta.discourse.org/t/how-to-pull-all-valid-email-address-from-console-in-my-server/50657 "2016-09-26T03:55:28Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![doudou](https://avatars.discourse-cdn.com/v4/letter/d/5e9695/32.png) [@doudou](https://meta.discourse.org/u/doudou)\
**Post date:** [2016年九月26日 03:55 UTC](https://meta.discourse.org/t/how-to-pull-all-valid-email-address-from-console-in-my-server/50657/1 "2016-09-26T03:55:28Z")

</div>

How to pull all valid email address (drop the banned email account) from console in my server?

an account in one line

thanks

---

<div class="post-metadata">

**Author:** ![tgxworld](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tgxworld/32/106117_2.png) [@tgxworld](https://meta.discourse.org/u/tgxworld)\
**Post date:** [2016年九月26日 06:04 UTC](https://meta.discourse.org/t/how-to-pull-all-valid-email-address-from-console-in-my-server/50657/2 "2016-09-26T06:04:13Z")

</div>

Try:

```plaintext
cd /var/discourse
./launcher enter app
rails c
User.activated.joins(:user_emails).pluck(:email)

```

If you want to use this in a cron job you could do something like:

```plaintext
docker exec app /usr/local/bin/rails r 'puts User.activated.joins(:user_emails).pluck(:email)'

```

---

<div class="post-metadata">

**Author:** ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)\
**Post date:** [2019年三月11日 09:05 UTC](https://meta.discourse.org/t/how-to-pull-all-valid-email-address-from-console-in-my-server/50657/7 "2019-03-11T09:05:53Z")

</div>