# Kan Discourse een lijst produceren van de e-mails waarnaar ik uitnodigingen heb gestuurd

**URL:** https://meta.discourse.org/t/can-discourse-produce-a-list-of-the-emails-that-i-have-sent-invitations-to/272904
**Category:** Support
**Tags:** email, invites
**Created:** [26 juli 2023 om 10:57 UTC](https://meta.discourse.org/t/can-discourse-produce-a-list-of-the-emails-that-i-have-sent-invitations-to/272904 "2023-07-26T10:57:56Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![GetReadyMan](https://avatars.discourse-cdn.com/v4/letter/g/bbe5ce/32.png) [@GetReadyMan](https://meta.discourse.org/u/GetReadyMan)
#### Post date: [26 juli 2023 om 10:57 UTC](https://meta.discourse.org/t/can-discourse-produce-a-list-of-the-emails-that-i-have-sent-invitations-to/272904/1 "2023-07-26T10:57:57Z")

</div>

After I sent invitations to about 350 emails, my hard drive crashed and I lost my list of emails.

Discourse shows the emails of the invitations on the “pending invites” and “expired invites” page.

Is there a way Discourse can produce a list of all the invite emails, or must I copy them one-by-one?

---

<div class="post-metadata">

### Author: ![Canapin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/canapin/32/119591_2.png) [@Canapin](https://meta.discourse.org/u/Canapin)
#### Post date: [26 juli 2023 om 11:30 UTC](https://meta.discourse.org/t/can-discourse-produce-a-list-of-the-emails-that-i-have-sent-invitations-to/272904/2 "2023-07-26T11:30:40Z")

</div>

Hi Jerry 🙂

You could use [data explorer](https://meta.discourse.org/t/32566?silent=true) for this.  
The query should be something like:

```sql
SELECT email FROM invites
WHERE redeemed_at IS NULL

```

You can output the results in JSON or CSV.

To be tweaked if needed. Other fields may need to be added, like `deleted_at` or `invalidated_at`.

---

<div class="post-metadata">

### Author: ![GetReadyMan](https://avatars.discourse-cdn.com/v4/letter/g/bbe5ce/32.png) [@GetReadyMan](https://meta.discourse.org/u/GetReadyMan)
#### Post date: [26 juli 2023 om 12:03 UTC](https://meta.discourse.org/t/can-discourse-produce-a-list-of-the-emails-that-i-have-sent-invitations-to/272904/3 "2023-07-26T12:03:29Z")

</div>

Thanks Coin-coin! I’ll give that a try.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [25 augustus 2023 om 12:03 UTC](https://meta.discourse.org/t/can-discourse-produce-a-list-of-the-emails-that-i-have-sent-invitations-to/272904/4 "2023-08-25T12:03:45Z")

</div>

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