Question: Is there a way for admins/moderator to get some kind of push notification from the “Logs & screening” section? Like a message from the Automation plugin or something?
Context: We have had a couple incidents where old accounts are compromised and the email is changed. These accounts are then being used to message people and scam users.
I noticed that the add email log entries can be used to identify this issue in advance, though I don’t want to constantly be checking it. Is there a way to get a notification when this type of log entry shows up?
I got this data explorer query that I added as a report that can allow checking but doesn’t do a “push” notification when there’s an update.
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
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