# 有没有办法从日志中获取主题关闭事件的列表？

**URL:** <https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200>\
**Category:** Product Support\
**Created:** [2019 年2 月 2 日 09:46 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:** 1\
**Showing post:** 4

<div class="post-metadata">

作者： ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)\
发布日期： [2019 年2 月 4 日 00:21 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

```

---

_[View the full topic](https://meta.discourse.org/t/is-there-any-way-to-get-a-list-of-topic-close-events-from-the-logs/108200)._