I migrated about 250 users that I’d now like to mark as inactive because they haven’t visited the forum in quite some time. Is there a way to bulk deactivate users with a ‘last seen’ date prior to some date? My goal is to prevent emails from sending to these users. I think deactivation is the corre…

A simpler solution might be to adjust suppress digest email after days. They’d still be “active” but they’d stop getting notices. But, if you want, it’s something like this: cd /var/discourse ./launcher enter app rails c User.where("last_seen_at < '2016-01-01'").update_all(active: false) exit exit…

That setting seems to only impact digest emails. Many of the categories are setup as “watch” by default, so users are getting per-post emails - not digest. Do I understand that correctly? EDIT: I see emails going out to users that have been inactive for more than 365 days.

[image] codechef: . Many of the categories are setup as “watch” by default, so users are getting per-post emails - not digest. Do I understand that correctly? I think you’re right. The code I provided, though untested, should do what you want. You should backup your database before trying it. …

Quick follow up. This script worked perfectly! I tested it in a demo environment first. Two minor suggestions: I added “and active = true” to the where criteria because I wasn’t sure if there’d be side effects to deactivating an inactive user. People that come across this post is the future may w…

Since this is an old topic is bulk deactivation of inactive users now a feature of discourse or do you still need to run @pfaffman code as the only solution?

Bulk deactivation of inactive users

Support

JammyDodger June 4, 2024, 2:26pm 7

I think there’s a plugin now which you may find useful:

https://github.com/discourse/discourse-auto-deactivate

Topic		Replies	Views
Bulk deactivate users with SQL query Support	1	783	May 31, 2018
How to set all users notifying email preferences to none? Support	7	861	February 13, 2020
Automatic/Bulk deleting inactive users Feature	13	1457	May 4, 2019
Please eval short Ruby script to suspend inactive users Development	3	186	September 4, 2024
How to deactive account of those users who're not receiving emails Support	4	786	November 10, 2022

Bulk deactivation of inactive users

Related topics