We’ve a default setup for the system to clean inactive users. I believe the default criteria are something like: last_posted_at date (never posted), TL0 not seen for (by default) 2 years These criteria generally work very well in cleaning out the user base. But is there a way to produce a list s…

[图片] Amicable: and really bad with technology. Yet highly valued. You can change their trust level and lock it to another value than 0. :slight_smile: It will prevent them from being picked up by the cleanup inactive user jobs.

Hi Amicable! Using data explorer , the query would be: WITH posts_by_user AS ( SELECT COUNT(*) AS posts, user_id FROM posts GROUP BY user_id ) SELECT u.id, u.username_lower AS "username", u.created_at, u.last_seen_at FROM users u LEFT JOIN posts_by_user pbu ON pbu.user_…

That looks very useful. I didn’t know about the data explorer , so will start there. Thank you very much for your solution :+1:

Out of curiosity, what is the purpose? Admins usually are active, post and log in. edit: I might have misunderstood this part: [图片] Amicable: to produce a list showing admins users :slight_smile: In this case, just remove and admin = true from the SQL query. I updated the SQL code direct…

It’s for a list showing us admins users. But the wider use case is maybe interesting. We use email digests quite a lot because some of our community are valued but busy older people unlikely to post and less likely to log in. But they are very familiar with email and they like to remain updated. B…

Oh, I see. Basically, they read by email and browse logged off pretty much all the time. I’m not sure how to handle that. Surely someone will have a good idea. A straightforward one would for them to at least post 1 message on the forum, though. Also, note that digests are disabled for users that …

yes, exactly. It would be nice if they posted once. But imagine someone extremely time poor and really bad with technology. Yet highly valued. The digests are superb for them and the community knows they belong & doesn’t mind they don’t actively contribute online.

The simplest solutions are the best :tada:

如何列出系统即将删除的用户？

支持

Amicable 2023 年5 月 24 日 10:17 5

这看起来很有用。我不知道数据浏览器，所以将从那里开始。非常感谢您的解决方案

话题		回复	浏览量
"clean up inactive users after days" meaning and statistics Data & reporting	3	112	2024 年11 月 14 日
Turn off discourse deleting inactive users Support	1	513	2022 年9 月 2 日
What to do with inactive users Community Building	21	473	2026 年2 月 8 日
Queries for inactive and active users? Support	6	2314	2018 年12 月 28 日
Automatic/Bulk deleting inactive users Feature	14	1299	2019 年5 月 4 日

如何列出系统即将删除的用户？

相关话题