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…

[imagen] 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) 22 Febrero, 2016 06:24 2

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

Tema		Respuestas	Vistas
Data explorer query for all active users (Lurkers + Posters) Data & reporting sql-query	5	1084	25 Noviembre 2024
"clean up inactive users after days" meaning and statistics Data & reporting	3	186	14 Noviembre 2024
How to measure active users? Data & reporting sql-query	15	5110	6 Marzo 2025
Automatic/Bulk deleting inactive users Feature	13	1476	4 Mayo 2019
How to find the most active users over the last month Data & reporting	5	800	4 Marzo 2024

Queries for inactive and active users?

Temas relacionados