I am seeing suspicious activity in my user to user private message chart. Its been 20 times more in 3 successive days. now how can I detect who has messaged others the most on those days?

If you are an admin you can see the latest PM with a similar link http://your-site.com/private-posts.rss It’s not accurate but you can see if a particular user send more PM in a day. Or you can run a query to have a list of users and PM in the last X days (you need to install Data explorer plugin ). …

Make sure you have the Data Explorer plugin installed, navigate to Admin → Plugins → Data Explorer , create a new query and paste in this SQL code: SELECT user_id, count(*) AS message_count FROM topics WHERE archetype = 'private_message' AND subtype = 'user_to_user' AND age(created_at) < interval '7…

I wanted to use that rss link however it only shows me the few recent ones. Is there an option to at least increase the number of message in that rss?

It turns out that the culprit is @discobot . I don’t know why its messages are counted as user to user messages. Because to me a bot isn’t a user.

Perhaps the user to user stat should ignore user ids less than zero. (The bot offering to help Hosein just after he wrote that the bot isn’t a user really made me laugh - did it also send you a PM @hnaseri ? )

:smile: Exactly it made me laugh too. No I didn’t get any PM. [image] JagWaugh: Perhaps the user to user stat should ignore user ids less than zero. thats a great Idea if possible. Would have saved me couple of hours.

Who messaged the most?

Community Building Data & reporting

dax (Daniela) Juin 5, 2017, 3:07 5

Sincerly I have no idea if this is possible.

The query that @fefrei share for you is certantly a more accurate method and you can change the interval of days in 2 or 3 instead of 7 if you want

Sujet		Réponses	Vues
Tracking who sent private messages Data & reporting sql-query	1	3090	Août 25, 2018
Who has been sending the most messages in the last week? Data & reporting sql-query	0	189	Juin 5, 2017
Identify private message interactions between users Data & reporting sql-query	1	904	Octobre 13, 2020
Dashboard Report - User-to-User Data & reporting sql-query , dashboard-reports , dashboard-sql	0	579	Décembre 13, 2023
Most Direct Messages (interval) Data & reporting chat , sql-query	0	325	Août 31, 2023

Who messaged the most?

Sujets connexes