# Silenced\_till reason
**URL:** https://meta.discourse.org/t/silenced-till-reason/131814
**Category:** Support
**Created:** [24 oktober 2019 om 16:26 UTC](https://meta.discourse.org/t/silenced-till-reason/131814 "2019-10-24T16:26:47Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)
#### Post date: [24 oktober 2019 om 16:26 UTC](https://meta.discourse.org/t/silenced-till-reason/131814/1 "2019-10-24T16:26:47Z")
I was to query for why users were silenced. I tried to take an educated guess and search for fields with **silence** in the name but I’m still not seeing it:
```sql
select t.table_schema,
t.table_name
from information_schema.tables t
inner join information_schema.columns c on c.table_name = t.table_name
and c.table_schema = t.table_schema
where c.column_name LIKE 'silence%'
and t.table_schema not in ('information_schema', 'pg_catalog')
and t.table_type = 'BASE TABLE'
order by t.table_schema;
```
---
### Author:  [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [24 oktober 2019 om 17:24 UTC](https://meta.discourse.org/t/silenced-till-reason/131814/2 "2019-10-24T17:24:54Z")
Try this:
```sql
SELECT acting_user_id, target_user_id AS silenced_user_id, details AS reason, created_at
FROM user_histories
WHERE user_histories.action = 30
```
---
### Author:  [@slackmoehrle](https://meta.discourse.org/u/slackmoehrle)
#### Post date: [24 oktober 2019 om 17:31 UTC](https://meta.discourse.org/t/silenced-till-reason/131814/3 "2019-10-24T17:31:20Z")
Thank you. I didn’t think to look at user\_histories as I thought it would be their history and not the history of actions taken against them.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [23 november 2019 om 17:38 UTC](https://meta.discourse.org/t/silenced-till-reason/131814/4 "2019-11-23T17:38:24Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.