# Data Explorer query to identify trust level change dates

**URL:** <https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037>\
**Category:** Data & reporting\
**Tags:** sql-query\
**Created:** [September 14, 2020, 9:11pm UTC](https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037 "2020-09-14T21:11:26Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![simon](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/simon/32/339122_2.png) [@simon](https://meta.discourse.org/u/simon)\
**Post date:** [September 15, 2020, 7:33pm UTC](https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037/2 "2020-09-15T19:33:29Z")

</div>

> [@Randy\_Hulett](#):
>
> Does the database contain information on when a user’s trust level changes?

Yes, the `group_users` `created_at` field can be used for that. It will be set to the date when the user was added to the group. You could try running a query like the one below at periodic intervals to find all users who were added to the group during the interval. The query’s `granted_at` field expects a date in the form `yyyy-mm-dd`. For example `2020-09-15`

```sql
--[params]
-- string :group_name = trust_level_3
-- date :granted_at

SELECT
user_id,
gu.created_at::date
FROM group_users gu
JOIN groups g
ON g.id = gu.group_id
WHERE gu.created_at::date >= :granted_at
AND g.name = :group_name

```

If you need more user details, it would be possible to update the query to join the `users` table, or the `user_emails` table.

---

_[View the full topic](https://meta.discourse.org/t/data-explorer-query-to-identify-trust-level-change-dates/164037)._