This is described as: Number of days before an inactive user (trust level 0 without any posts) is removed. To disable clean up set to 0. Can you confirm that these are the criteria (TL0 and 0 posts)? Is any account taken of when they last logged in and/or read a post, or does the number of days start from registration? Is there a data explorer query to show TL0 users who have 0 posts alongside the relevant number of days? This would be to give an idea of the effect of choosing specific numbers for this setting. Thanks.

There are some additional criteria: admins and moderators aren’t deleted Also the last seen and the registration date are checked. app/jobs/scheduled/clean_up_inactive_users.rb 53f9c8179 User .where( last_posted_at: nil, trust_level: TrustLevel.levels[:newuser], admin: false, moderator: false, ) .where("users.created_at < ?", SiteSetting.clean_up_inactive_users_after_days.days.ago) .where( "users.last_seen_at < ? OR users.last_seen_at IS NULL", SiteSetting.clean_up_inactive_users_after_days.days.ago, ) .where .missing(:posts, :topics) .limit(1000) .pluck(:id) .each_slice(50) { |slice| destroy(slice) } end private I think something like this should return the number of users that would be deleted -- [params] -- int :active_days_ago SELECT COUNT(*) FROM users WHERE last_posted_at IS NULL AND trust_level = 0 AND admin = false AND moderator = false AND created_at < CURRENT_DATE - :active_days_ago AND (last_seen_at < CURRENT_DATE - :active_days_ago OR last_seen_at IS NULL) AND NOT EXISTS ( SELECT 1 FROM posts WHERE posts.user_id = users.id ) AND NOT EXISTS ( SELECT 1 FROM topics WHERE topics.user_id = users.id ) To see which users would be deleted this should work -- [params] -- int :active_days_ago SELECT id as user_id, DATE_PART('day', CURRENT_DATE - created_at) AS days_since_created, DATE_PART('day', CURRENT_DATE - last_seen_at) AS days_since_seen FROM users WHERE last_posted_at IS NULL AND trust_level = 0 AND admin = false AND moderator = false AND created_at < CURRENT_DATE - :active_days_ago AND (last_seen_at < CURRENT_DATE - :active_days_ago OR last_seen_at IS NULL) AND NOT EXISTS ( SELECT 1 FROM posts WHERE posts.user_id = users.id ) AND NOT EXISTS ( SELECT 1 FROM topics WHERE topics.user_id = users.id ) ORDER BY days_since_seen

[image] Jonathan5: or (being logged in) viewing any page of the forum? It is this. The last time they were actively viewing the forums.

"clean up inactive users after days" meaning and statistics

Community Building Data & reporting

Jonathan5 November 13, 2024, 6:26pm 3

Thanks. I’ll try that.

The admin setting text needs to be updated as it’s wrong.

What’s last_seen_at based on? Logging in, or (being logged in) viewing any page of the forum?

Topic		Replies	Views
Automatic/Bulk deleting inactive users Feature	13	1488	May 4, 2019
Does discourse automatically remove inactive members? Product Support	7	2501	February 9, 2022
How might I list users that the system will soon delete? Product Support	8	846	May 24, 2023
Why would the number of all time sign-ups ever decrease? Product Support	6	551	March 30, 2023
System deleting users: 'inactive user', 'Automatically deleted as abandoned, deactivated account', and 'staged unused' Product Support	7	866	October 16, 2024

"clean up inactive users after days" meaning and statistics

Related topics