# Retrieve a list of active conversation\_ids

**URL:** <https://forum.rasa.com/t/retrieve-a-list-of-active-conversation-ids/47726>\
**Category:** Rasa Open Source\
**Created:** [September 14, 2021, 12:16pm UTC](https://forum.rasa.com/t/retrieve-a-list-of-active-conversation-ids/47726 "2021-09-14T12:16:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![somebody](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@somebody](https://forum.rasa.com/u/somebody)\
**Post date:** [September 14, 2021, 12:16pm UTC](https://forum.rasa.com/t/retrieve-a-list-of-active-conversation-ids/47726/1 "2021-09-14T12:16:42Z")

</div>

Hi is there a way to retrieve a list of all active conversation\_ids?

---

<div class="post-metadata">

**Author:** ![ChrisRahme](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/chrisrahme/32/15572_2.png) [@ChrisRahme](https://forum.rasa.com/u/ChrisRahme)\
**Post date:** [September 15, 2021, 12:58pm UTC](https://forum.rasa.com/t/retrieve-a-list-of-active-conversation-ids/47726/2 "2021-09-15T12:58:37Z")

</div>

[Rasa X HTTP API](https://rasa.com/docs/rasa-x/pages/http-api#operation/getConversations):

```auto
GET /conversations

```

This will get all conversations.

As for **active** conversations, there is no way to know that I know of.

---

<div class="post-metadata">

**Author:** ![somebody](https://avatars.discourse-cdn.com/v4/letter/s/3ab097/32.png) [@somebody](https://forum.rasa.com/u/somebody)\
**Post date:** [September 15, 2021, 3:15pm UTC](https://forum.rasa.com/t/retrieve-a-list-of-active-conversation-ids/47726/3 "2021-09-15T15:15:27Z")

</div>

Thank you, but is there way to get such a list from rasa and not rasa x? The rasa REST API doesn’t list such an endpoint: [https://rasa.com/docs/rasa/pages/http-api](https://rasa.com/docs/rasa/pages/http-api)

---

<div class="post-metadata">

**Author:** ![ChrisRahme](https://dub1.discourse-cdn.com/flex013/user_avatar/forum.rasa.com/chrisrahme/32/15572_2.png) [@ChrisRahme](https://forum.rasa.com/u/ChrisRahme)\
**Post date:** [September 15, 2021, 3:21pm UTC](https://forum.rasa.com/t/retrieve-a-list-of-active-conversation-ids/47726/4 "2021-09-15T15:21:00Z")

</div>

You can also query the tracker store. In MySQL:

```sql
SELECT DISTINCT sender_id from tracker_store

```

And for a loose definition of “active conversations”, you can check if the timestamp is less than, e.g., 5 minutes ago. In Python:

```python
now = int(time.time()) # Current timestamp
recent = now - (5 * 60) # Timestamp 5 minutes ago

sql = f"SELECT DISTINCT sender_id FROM tracker_store WHERE timestamp > {recent}"

conversations = database.query(sql)

```