Remove user accounts older than 2 years with Auto Actions

Hello:

To accomplish with GDPR we need delete user account, profile, folder with documentation, avatar, etc from people with lastupdatedate older than 2 years, or people who never have logged in into the account.

I'm working in an Auto Action batch proccess triggered by a cron job:

- Global > Access: Registered.
-Action: Remove account (action to develope, see next paragraph).
- Advanced Filter > WHERE:

How I can develope the Remove account action? Maybe there are some programmatically substitution to do it? Or I must write a complex SQL action? I haven't found any system action to remove user profile in Auto Actions.

Thank you

I do not recommend automating deletions. 1 mistake and you just wiped your whole database of users. Please just do this manually once a year. You can filter CB > User Management by last visit date, registration date, and last update date as needed.

Additionally I recommend installing CB Privacy and letting users delete themselves whenever they like as it provides a delete account feature. This will provide them the right to erasure.

Well, I agree but we need to block unoperative users  access once a month. An SQL Auto Action will change block field in user table. We'll do the users deletion as manual once a year more o less.

cb_privacy as you mention is installed and working like a charm some years ago. Some people use it, but lot of people simply let their account sleeping.

Thank you

If you just need to quickly toggle them to be blocked I suggest using a Query action and just writing an update query to do that. You shouldn't need to touch CBs tables only Joomla's _users table. You can then run that auto action on a schedule from CRON or using Joomla 4 schedule tasks component.