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…

[image] 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) February 22, 2016, 6:24am 2

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

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

Queries for inactive and active users?

Related topics