I had someone tell me some fishy stuff going on in some PM’s, but I do NOT know who is doing it. As an Admin, I’m trying to find it. I can’t search all the messages in our community can I? Other than clicking a whole bunch of names and trying to find the perp?

SELECT posts.user_id, posts.topic_id, posts.raw, posts.created_at FROM posts LEFT JOIN topics ON topics.id = posts.topic_id WHERE subtype = 'user_to_user' AND (raw LIKE '% naughty %' OR raw LIKE '% illegal %' OR raw LIKE '% sexy %') ORDER BY posts.created_at desc Just edit the words naughty/illega…

Do you have keywords to search for? Something like this seems like a “show me the last 25-50-75 PMs” situation, perhaps?

Yea that would work. I do have some keywords, but it could also be hard to find just by keyword. Hence a * search too.

I suggest looking at the PMs of the most recently active users to start with: /admin/users/list/active Beyond that, a Data Explorer query would be fairly simple to construct since you are limiting your view to PM body text, ordered by time descending.

Can you elaborate on fishy stuff? Is this high volume messaging? Inappropriate content? Off-site links? It’s far easier to help you cast a net if we know what you’re trying to catch.

Thanks for all the help this is what makes this product truly unique and great. Will let you know how it goes.

Note we now have in:all-pms for this feature: FEATURE: Search filter for searching all PMs on a site for admin. master ← search_pms merged 04:56PM - 19 Nov 20 UTC (UTC) …

以管理员身份搜索所有消息

支持

Canapin (Coin-coin le Canapin) 2020 年9 月 21 日 21:59 2

If you know a bit of the PM’s content, you can use Data Explorer and do SQL queries: Data Explorer Plugin

1 个赞

话题		回复	浏览量
Finding PMs sent to users who never posted in the topic Feature	19	1003	2021 年7 月 11 日
[PAID] Private Message indexer with search filters Marketplace	1	811	2018 年9 月 9 日
Tracking who sent private messages Data & reporting sql-query	2	3016	2018 年8 月 25 日
Pressing return when searching in messages returns no results Bug	18	2770	2015 年8 月 16 日
Is there any way to pull in bulk all topics/posts and DMs with a certain keyword? Data & reporting sql-query	1	615	2021 年1 月 14 日

以管理员身份搜索所有消息

相关话题