# Get admin notification from logs?

**URL:** <https://meta.discourse.org/t/get-admin-notification-from-logs/363729>\
**Category:** Product Support\
**Tags:** notifications\
**Created:** [April 28, 2025, 4:09am UTC](https://meta.discourse.org/t/get-admin-notification-from-logs/363729 "2025-04-28T04:09:13Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![piffy](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/piffy/32/254198_2.png) [@piffy](https://meta.discourse.org/u/piffy)\
**Post date:** [April 30, 2025, 10:29pm UTC](https://meta.discourse.org/t/get-admin-notification-from-logs/363729/3 "2025-04-30T22:29:59Z")

</div>

I got this [data explorer](https://meta.discourse.org/t/32566?silent=true) query that I added as a report that can allow checking but doesn’t do a “push” notification when there’s an update.

```sql
SELECT 
    uh.action,
    acting.username AS acting_user,
    target.username AS target_user,
    uh.updated_at
FROM user_histories uh
LEFT JOIN users acting ON acting.id = uh.acting_user_id
LEFT JOIN users target ON target.id = uh.target_user_id
WHERE uh.action = 88
  AND uh.updated_at > CURRENT_DATE - INTERVAL '7 days'
ORDER BY uh.updated_at DESC
LIMIT 100

```

---

_[View the full topic](https://meta.discourse.org/t/get-admin-notification-from-logs/363729)._