# Tracciamento di chi ha inviato messaggi privati
**URL:** https://meta.discourse.org/t/tracking-who-sent-private-messages/95607
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [24 Agosto 2018, 10:19pm UTC](https://meta.discourse.org/t/tracking-who-sent-private-messages/95607 "2018-08-24T22:19:59Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@nexo](https://meta.discourse.org/u/nexo)
#### Post date: [24 Agosto 2018, 10:20pm UTC](https://meta.discourse.org/t/tracking-who-sent-private-messages/95607/1 "2018-08-24T22:20:00Z")
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](https://meta.discourse.org/t/32566?silent=true) plugin? I just started using this plugin so sorry if I missed this. Thanks.
---
### Author:  [@nexo](https://meta.discourse.org/u/nexo)
#### Post date: [25 Agosto 2018, 12:31am UTC](https://meta.discourse.org/t/tracking-who-sent-private-messages/95607/2 "2018-08-25T00:31:52Z")
Nevermind, I found how:
> [@Who messaged the most?](https://meta.discourse.org/t/who-messaged-the-most/63963/3):
>
> Make sure you have the [Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566) 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 …
---
### Author:  [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [25 Agosto 2018, 10:07am UTC](https://meta.discourse.org/t/tracking-who-sent-private-messages/95607/3 "2018-08-25T10:07:39Z")