# Get admin notification from logs?

**URL:** https://meta.discourse.org/t/get-admin-notification-from-logs/363729
**Category:** 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:** 4

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [May 7, 2025, 12:05pm UTC](https://meta.discourse.org/t/get-admin-notification-from-logs/363729/4 "2025-05-07T12:05:42Z")

</div>

Could you refine that query slightly and rig it up to a recurring ‘schedule a PM with [data explorer](https://meta.discourse.org/t/32566?silent=true) results’ automation? If you select ‘skip if no results’ and adjust the automation frequency to match the time interval in the query then it may work as a ‘push notification’ type ping?

Something like this (with a recurring automation frequency of 30 minutes):

```sql
SELECT 
    uh.created_at AS "email updated",
    uh.acting_user_id,
    uh.target_user_id
FROM user_histories uh
WHERE uh.action = 88
  AND uh.updated_at > CURRENT_TIMESTAMP - INTERVAL '30 minutes'
ORDER BY 1 DESC

```

---

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