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…

[imagem] 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. [imagem] 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) Junho 5, 2017, 3:01pm 4

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?

Tópico		Respostas	Visualizações
Tracking who sent private messages Data & reporting sql-query	1	3090	25 de Agosto de 2018
Who has been sending the most messages in the last week? Data & reporting sql-query	0	189	5 de Junho de 2017
Identify private message interactions between users Data & reporting sql-query	1	904	13 de Outubro de 2020
Dashboard Report - User-to-User Data & reporting sql-query , dashboard-reports , dashboard-sql	0	579	13 de Dezembro de 2023
Most Direct Messages (interval) Data & reporting chat , sql-query	0	325	31 de Agosto de 2023

Who messaged the most?

Tópicos relacionados