# Is there any way to get a list of topic close events from the logs?

**URL:** <https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200>\
**Category:** Support\
**Created:** [February 2, 2019, 9:46am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200 "2019-02-02T09:46:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![1101010](https://avatars.discourse-cdn.com/v4/letter/1/6de8d8/32.png) [@1101010](https://meta.discourse.org/u/1101010)\
**Post date:** [February 2, 2019, 9:46am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200/1 "2019-02-02T09:46:16Z")

</div>

It doesn’t seem like there is.

Also I tried searching but couldn’t find anything about this, sorry.

But yes, I note there are events for deletion and the like but nothing for closing topics.

Is that because this is a leader action and we don’t log those? Would be good to note the Leader actions somewhere if not.

Thanks

---

<div class="post-metadata">

**Author:** ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)\
**Post date:** [February 2, 2019, 9:52am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200/2 "2019-02-02T09:52:07Z")

</div>

What do you mean “lock”? Do you mean close the topic? Or are you referring to the per-post action?

---

<div class="post-metadata">

**Author:** ![1101010](https://avatars.discourse-cdn.com/v4/letter/1/6de8d8/32.png) [@1101010](https://meta.discourse.org/u/1101010)\
**Post date:** [February 2, 2019, 10:51am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200/3 "2019-02-02T10:51:26Z")

</div>

Apologies, yes I mean close the topic. Because of the padlock symbol being what I saw in my mind’s eye I could only think of lock as it’s the one on other forums.

---

<div class="post-metadata">

**Author:** ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)\
**Post date:** [February 4, 2019, 12:21am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200/4 "2019-02-04T00:21:11Z")

</div>

I would not be searching for topic close events… instead for all posts that are close actions in [data explorer](https://meta.discourse.org/t/32566?silent=true) should do the trick.

Try this query:

```plaintext
SELECT topic_id, user_id, action_code, created_at
FROM posts
WHERE post_type = 3 AND action_code like '%closed%'
ORDER BY created_at DESC
LIMIT 100

```

---

<div class="post-metadata">

**Author:** ![1101010](https://avatars.discourse-cdn.com/v4/letter/1/6de8d8/32.png) [@1101010](https://meta.discourse.org/u/1101010)\
**Post date:** [February 4, 2019, 2:05am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200/5 "2019-02-04T02:05:31Z")

</div>

Ah okay, thanks a lot.

We don’t have that plugin installed. I’ll see if the owner wants it but probably it won’t happen.

It’s not wildly important I just wondered if I was missing something that could tell us this.

Thanks for the help

---

<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:** [March 6, 2019, 2:05am UTC](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200/6 "2019-03-06T02:05:32Z")

</div>

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