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) 9월 21, 2020, 9:59오후 2

PM 콘텐츠에 대해 조금만 알고 있다면, Data Explorer를 사용하여 SQL 쿼리를 실행할 수 있습니다: Discourse Data Explorer

글		댓글	조회수
Finding PMs sent to users who never posted in the topic Feature	19	1186	7월 11, 2021
[PAID] Private Message indexer with search filters Marketplace	0	841	8월 10, 2018
Tracking who sent private messages Data & reporting sql-query	1	3094	8월 25, 2018
Pressing return when searching in messages returns no results Bug	17	3008	8월 16, 2015
Is there any way to pull in bulk all topics/posts and DMs with a certain keyword? Data & reporting sql-query	1	667	1월 14, 2021

관리자 권한으로 모든 메시지 검색하기

Related topics