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?

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

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: https://github.com/discourse/discourse/pull/11280

Поиск всех сообщений как администратор

Поддержка

Canapin (Coin-coin le Canapin) 21.Сентябрь.2020 21:59:28 2

Если вы немного знакомы с контентом PM, вы можете использовать Data Explorer и выполнять SQL-запросы: Discourse Data Explorer

Тема		Ответов	Просм.
Finding PMs sent to users who never posted in the topic Feature	19	1086	11.07.2021
[PAID] Private Message indexer with search filters Marketplace	0	825	10.08.2018
Tracking who sent private messages Data & reporting sql-query	1	3049	25.08.2018
Pressing return when searching in messages returns no results Bug	17	2845	16.08.2015
Is there any way to pull in bulk all topics/posts and DMs with a certain keyword? Data & reporting sql-query	1	640	14.01.2021

Поиск всех сообщений как администратор

Связанные темы