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?

[image] hnaseri: Is there an option to at least increase the number of message in that rss? 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

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

hnaseri (Hosein Naseri) June 5, 2017, 6:27pm 9

Exactly it made me laugh too. No I didn’t get any PM.

thats a great Idea if possible. Would have saved me couple of hours.

Topic		Replies	Views
Tracking who sent private messages Data & reporting sql-query	1	3090	August 25, 2018
Who has been sending the most messages in the last week? Data & reporting sql-query	0	189	June 5, 2017
Identify private message interactions between users Data & reporting sql-query	1	904	October 13, 2020
Dashboard Report - User-to-User Data & reporting sql-query , dashboard-reports , dashboard-sql	0	579	December 13, 2023
Most Direct Messages (interval) Data & reporting chat , sql-query	0	325	August 31, 2023

Who messaged the most?

Related topics