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

Buscando todos los mensajes como administrador

Soporte

Canapin (Coin-coin le Canapin) 21 Septiembre, 2020 21:59 2

Si conoces un poco el contenido del PM, puedes usar el Explorador de Datos y realizar consultas SQL: Discourse Data Explorer

Tema		Respuestas	Vistas
Finding PMs sent to users who never posted in the topic Feature	19	1059	11 Julio 2021
[PAID] Private Message indexer with search filters Marketplace	1	822	9 Septiembre 2018
Tracking who sent private messages Data & reporting sql-query	2	3039	25 Agosto 2018
Pressing return when searching in messages returns no results Bug	18	2808	16 Agosto 2015
Is there any way to pull in bulk all topics/posts and DMs with a certain keyword? Data & reporting sql-query	1	630	14 Enero 2021

Buscando todos los mensajes como administrador

Temas relacionados