# האם אפשר לעקוב אחר אזכורי משתמשים?

**URL:** https://meta.discourse.org/t/is-it-possible-to-keep-track-of-user-mentions/231031
**Category:** Data & reporting
**Tags:** sql-query, mentions
**Created:** [24 ביוני,‏ 2022,‏ 4:23pm UTC](https://meta.discourse.org/t/is-it-possible-to-keep-track-of-user-mentions/231031 "2022-06-24T16:23:29Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Tara\_Walton](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tara_walton/32/244402_2.png) [@Tara\_Walton](https://meta.discourse.org/u/Tara_Walton)
#### Post date: [24 ביוני,‏ 2022,‏ 4:23pm UTC](https://meta.discourse.org/t/is-it-possible-to-keep-track-of-user-mentions/231031/1 "2022-06-24T16:23:29Z")

</div>

Continuing the discussion from [How to get the number of mentions groups have had over the past year, and number of members](https://meta.discourse.org/t/how-to-get-the-number-of-mentions-groups-have-had-over-the-past-year-and-number-of-members/174548):

I found this ☝ topic when I was looking for a way to see how often someone is tagged/mentioned.

I have a product-driven forum with users that our forum likes to call on for advice/expertise/etc, but we don’t want to always bother the same people and would like to spread the love. **Am I missing a way to keep track of who has been mentioned/tagged?**

---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [27 ביוני,‏ 2022,‏ 6:47pm UTC](https://meta.discourse.org/t/is-it-possible-to-keep-track-of-user-mentions/231031/7 "2022-06-27T18:47:36Z")

</div>

Mentions look like they crop up a couple of times in the tables, either in `notifications` or `user_actions`, so it may be possible to use those? It’s not a query I’ve considered before so this may have some holes in it 🙂 But maybe something like this could give you a list of ‘most mentioned users by staff in the last month’? From there it could perhaps be tweaked to suit your specifics a bit more?

```plaintext
SELECT ua.user_id, 
       count(ua.user_id)
FROM user_actions ua
JOIN group_users gu ON gu.user_id = ua.acting_user_id
WHERE ua.action_type = 7
AND gu.group_id = 3
AND ua.created_at >= CURRENT_DATE - INTERVAL '1 MONTH'
GROUP BY ua.user_id
ORDER BY count(ua.user_id) DESC
LIMIT 100

```

---

<div class="post-metadata">

### Author: ![Tara\_Walton](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/tara_walton/32/244402_2.png) [@Tara\_Walton](https://meta.discourse.org/u/Tara_Walton)
#### Post date: [27 ביוני,‏ 2022,‏ 7:41pm UTC](https://meta.discourse.org/t/is-it-possible-to-keep-track-of-user-mentions/231031/8 "2022-06-27T19:41:46Z")

</div>

Thanks @JammyDodger !  
I’ll play with this some. It definitely gives me help in where to look 😃

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [27 באוקטובר,‏ 2022,‏ 7:37pm UTC](https://meta.discourse.org/t/is-it-possible-to-keep-track-of-user-mentions/231031/9 "2022-10-27T19:37:14Z")

</div>

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.