# Who messaged the most?

**URL:** https://meta.discourse.org/t/who-messaged-the-most/63963
**Category:** Data & reporting
**Tags:** sql-query
**Created:** [5 Junio, 2017 14:37 UTC](https://meta.discourse.org/t/who-messaged-the-most/63963 "2017-06-05T14:37:58Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![dax](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/dax/32/244677_2.png) [@dax](https://meta.discourse.org/u/dax)
#### Post date: [5 Junio, 2017 14:57 UTC](https://meta.discourse.org/t/who-messaged-the-most/63963/2 "2017-06-05T14:57:07Z")

</div>

If you are an admin you can see the latest PM with a similar link [http://your-site.com/private-posts.rss](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](https://meta.discourse.org/t/data-explorer-plugin/32566)).

Something like this [SQL query to get the queue of all the PMs in the system - #3 by meglio](https://meta.discourse.org/t/sql-query-to-get-the-queue-of-all-the-pms-in-the-system/38089/3) is a good start point to write your own query.

---

_[View the full topic](https://meta.discourse.org/t/who-messaged-the-most/63963)._