Is there a way to do a Mass User Delete?  Allow me to explain...

I (regrettably) had my site set to public registration.  Apparently I got hit by a registration bot that registered over 3,000 fake users in one day.  Is there a simple way to un-authorize a bunch of users at once so I can use the "Delete Unauthorized Users" feature?  Or do I have to manually hit delete (and confirm) on each one of the 3,000 fake registrations?

Thanks for the input!

BTW... If there's not a way to do this... How do I do a feature request?

Whats the best way to prevent being hit by this registration bot?  I too have been hit in the last 48 hours and I set the site to verified with CAPTCA on and still got hit.

Hi Seb

I ran the SQL query to unauthorise the spam users. i.e.  UPDATE UserPortals SET isAuthorized= 0 which worked fine.

But the remove deleted user function in DNN 7.03.1 only seems to do a few at a time and not the same amount each time. I have 6000 to get rid of .

Is there a stored procedure I can run on the database - I looked but could not find it.