I intend to do some house cleaning on my discourse install. I want to identify two similar types of users: Inactive users without posts (pre-Discourse signups) Active users without posts and excessive read times (lurkers) I am going to get rid of #1s and seek creative ways to reach out to the #2…

[imagem] will_io: Inactive users without posts (pre-Discourse signups) SELECT u.id, u.username_lower AS "username", u.created_at, u.last_seen_at FROM users u WHERE u.active = false ORDER BY u.id Note: Since inactive users can’t create posts, we do not need to check for posts…

Possibly worth adding these queries to the “stock queries” that ship with data explorer

I modified the second query to accept a parameter and added both queries in: https://github.com/discourse/discourse-data-explorer/commit/7de1e5a68e1ddd1ca894c054647dc5da54a700c6

Queries for inactive and active users?

Product Support

codinghorror (Jeff Atwood) Fevereiro 22, 2016, 6:24am 2

Sure @techapj can you suggest some data explorer queries that might help here?

Tópico		Respostas	Visualizações
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	25 de Novembro de 2024
"clean up inactive users after days" meaning and statistics Data & reporting	3	187	14 de Novembro de 2024
How to measure active users? Data & reporting sql-query	15	5111	6 de Março de 2025
Automatic/Bulk deleting inactive users Feature	13	1476	4 de Maio de 2019
How to find the most active users over the last month Data & reporting	5	801	4 de Março de 2024

Queries for inactive and active users?

Tópicos relacionados