Tracking who sent private messages

[nexo]

Hi, recently my site has started growing and users have been messaging daily and I was wondering if it was possible to get a list of the users that PM’ed today (or a certain day/date) using the Data Explorer plugin? I just started using this plugin so sorry if I missed this. Thanks.

[nexo]

Nevermind, I found how:

Who messaged the most?

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 days' GROUP BY user_id ORDER BY message_count DESC This will show you all users that have messaged someone in the last 7 days, including the number of messages they have created. (Only new messages …