# Who marked Solution for Topic
**URL:** https://meta.discourse.org/t/who-marked-solution-for-topic/195179
**Category:** Support
**Created:** [June 27, 2021, 11:00pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179 "2021-06-27T23:00:32Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@ianm](https://meta.discourse.org/u/ianm)
#### Post date: [June 27, 2021, 11:00pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/1 "2021-06-27T23:00:32Z")
Is there a simple way for an Admin to see who has Marked Post as Solution?
---
### Author:  [@simon](https://meta.discourse.org/u/simon)
#### Post date: [June 28, 2021, 5:03pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/2 "2021-06-28T17:03:55Z")
There isn’t a simple way for an admin to see who has marked a post as the solution, but the information is available in the database. It can be retrieved with a [Data Explorer](https://meta.discourse.org/t/32566?silent=true) query. Here is a basic query that does that:
```sql
--[params]
-- int :topic_id
SELECT acting_user_id FROM user_actions WHERE action_type = 15 AND target_topic_id = :topic_id
```
---
### Author:  [@ianm](https://meta.discourse.org/u/ianm)
#### Post date: [June 29, 2021, 11:15pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/3 "2021-06-29T23:15:00Z")
We have a Hosted Discourse, so dont think we have [Data Explorer](https://meta.discourse.org/t/32566?silent=true).
Can this ability to see who has marked Solution for Topic be added to base line Discourse?
---
### Author:  [@supermathie](https://meta.discourse.org/u/supermathie)
#### Post date: [June 29, 2021, 11:21pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/4 "2021-06-29T23:21:02Z")
> [@ianm](#):
>
> Hosted Discourse, so dont think we have [Data Explorer](https://meta.discourse.org/t/32566?silent=true).
If you are on the Business tier or above, you have access to it. It may need to be enabled in your admin panel first.
---
### Author:  [@osioke](https://meta.discourse.org/u/osioke)
#### Post date: [June 30, 2021, 12:26pm UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/5 "2021-06-30T12:26:15Z")
You actually do 😉
Michael response is correct, you just have to enable it:
> [@Discourse Data Explorer](https://meta.discourse.org/t/discourse-data-explorer/32566/1):
>
> … head to `/admin/plugins` .
>
> 
>
> Click on the “Settings” button, and turn on `data explorer enabled` , then return and reload the page.
> There should now be a tab in the stacked nav called “[Data Explorer](https://meta.discourse.org/t/32566?silent=true)”. Select it or head to `/admin/plugins/explorer` , then use the + , Import or Run Query buttons to get started.
---
### Author:  [@ianm](https://meta.discourse.org/u/ianm)
#### Post date: [July 5, 2021, 5:49am UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/6 "2021-07-05T05:49:29Z")
Thank you, Simon and team
I have [data explorer](https://meta.discourse.org/t/32566?silent=true) enabled and have created the query:
`–[params]
– int :topic\_id
SELECT acting\_user\_id FROM user\_actions WHERE action\_type = 15 AND target\_topic\_id = :topic\_id`
Presume I need to be pointing to topic, but how then do I run the query?
Ah it seems I need to copy the topic\_id into the prompted window. 😉
Cheers
Ian
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [August 4, 2021, 5:49am UTC](https://meta.discourse.org/t/who-marked-solution-for-topic/195179/7 "2021-08-04T05:49:48Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.