# Query to find out who marked the solution as solved **URL:** https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153 **Category:** Support **Tags:** solved **Created:** [Juillet 13, 2017, 7:50 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153 "2017-07-13T19:50:32Z") **Posts on this page:** 1 **Showing post:** 2
### Author: ![david](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/david/32/157490_2.png) [@david](https://meta.discourse.org/u/david) #### Post date: [Juillet 13, 2017, 8:34 UTC](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153/2 "2017-07-13T20:34:06Z")
There’s some queries you can put into [data explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) here: > [@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… I’ve also just added them to the main `discourse-solved` topic, alongside the “badges” SQL queries > [@Discourse Solved](https://meta.discourse.org/t/discourse-solved-accepted-answer-plugin/30155): > > discourse2Summary Discourse Solved allows users to accept solutions on topics in designated categories.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately. Enabling Solved The Solved plugin can be enabled from its settings, accessed from your admin/plugins page: After enabling the plugin, to switch on Solved for all categories use the allow solved on all topics site setting. Alternati… --- _[View the full topic](https://meta.discourse.org/t/query-to-find-out-who-marked-the-solution-as-solved/66153)._