# Viewing the user who marks the solution

**URL:** https://meta.discourse.org/t/viewing-the-user-who-marks-the-solution/304660
**Category:** Support
**Tags:** solved
**Created:** [April 19, 2024, 7:20pm UTC](https://meta.discourse.org/t/viewing-the-user-who-marks-the-solution/304660 "2024-04-19T19:20:18Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![Moin](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/moin/32/554653_2.png) [@Moin](https://meta.discourse.org/u/Moin)
#### Post date: [April 19, 2024, 7:31pm UTC](https://meta.discourse.org/t/viewing-the-user-who-marks-the-solution/304660/2 "2024-04-19T19:31:01Z")

</div>

You can use the [data explorer](https://meta.discourse.org/t/32566?silent=true) to find that out

> [@Who has marked a particular topic as Solved](https://meta.discourse.org/t/who-has-marked-a-particular-topic-as-solved/261876):
>
> To look up who has marked a particular topic as Solved: -- [params] -- topic\_id :topic\_id SELECT target\_topic\_id, acting\_user\_id, created\_at::date FROM user\_actions WHERE target\_topic\_id = :topic\_id AND action\_type = 15 ORDER BY created\_at DESC

> [@How do I see who is marking solved and on what?](https://meta.discourse.org/t/how-do-i-see-who-is-marking-solved-and-on-what/63981/4):
>
> I was interested to see these stats for my instance as well, so had a go at making some queries for [data explorer](https://meta.discourse.org/t/32566?silent=true): To list each individual “solved” event: SELECT acting\_user\_id, target\_topic\_id, target\_post\_id, created\_at FROM user\_actions WHERE action\_type=15 ORDER BY created\_at DESC To produce a list with stats per-user: (with variable for time interval, defaults to 1 year): -- [params] -- string :interval = 1 year SELECT ua.acting\_user\_id, count(case t.user\_id when ua.acting\_use…

---

_[View the full topic](https://meta.discourse.org/t/viewing-the-user-who-marks-the-solution/304660)._