# Pull Event RSVP list via Data Explorer

**URL:** <https://meta.discourse.org/t/pull-event-rsvp-list-via-data-explorer/323119>\
**Category:** Data & reporting\
**Tags:** events, sql-query\
**Created:** [August 23, 2024, 6:14pm UTC](https://meta.discourse.org/t/pull-event-rsvp-list-via-data-explorer/323119 "2024-08-23T18:14:28Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![putty](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/putty/32/370902_2.png) [@putty](https://meta.discourse.org/u/putty)\
**Post date:** [August 23, 2024, 6:43pm UTC](https://meta.discourse.org/t/pull-event-rsvp-list-via-data-explorer/323119/3 "2024-08-23T18:43:11Z")

</div>

I was able to plug away at the following with the bot, but it is returning 0 results (even though I can see 30+ people have responded. The query works if I remove the WHERE statement.

> **[Deploying the BeyondTrust Password Safe Connector for IdentityIQ with Michel...](https://developer.sailpoint.com/discuss/t/deploying-the-beyondtrust-password-safe-connector-for-identityiq-with-michel-bluteau/68228)**
>
> ‼ The recording for this event can be viewed here: Join Expert Ambassador Michel Bluteau as he demonstrates how to configure and deploy the BeyondTrust Password Safe Connector in IIQ. Based on real customer deployments and the top five...

```plaintext
-- [params]
-- text :event_url = 'https://developer.sailpoint.com/discuss/t/deploying-the-beyondtrust-password-safe-connector-for-identityiq-with-michel-bluteau/68228'

SELECT 
    users.username AS "Username",
    invitees.status AS "RSVP Status",
    invitees.updated_at AS "Last Updated"
FROM 
    discourse_post_event_events AS events
JOIN 
    discourse_post_event_invitees AS invitees
ON 
    events.id = invitees.post_id
JOIN 
    users
ON 
    invitees.user_id = users.id
WHERE 
    events.url = :event_url

```

---

_[View the full topic](https://meta.discourse.org/t/pull-event-rsvp-list-via-data-explorer/323119)._