Get admin notification from logs?

Support
4

Could you refine that query slightly and rig it up to a recurring ‘schedule a PM with data explorer 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):

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
4 Likes