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 Todas as Mensagens como Administrador

Suporte

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

Se você conhece um pouco do conteúdo do PM, pode usar o Data Explorer e fazer consultas SQL: Discourse Data Explorer

Tópico		Respostas	Vistas
Finding PMs sent to users who never posted in the topic Feature	19	1093	11 Julho , 2021
[PAID] Private Message indexer with search filters Marketplace	0	825	10 Agosto , 2018
Tracking who sent private messages Data & reporting sql-query	1	3050	25 Agosto , 2018
Pressing return when searching in messages returns no results Bug	17	2850	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	642	14 Janeiro , 2021

Buscando Todas as Mensagens como Administrador

Related topics