I have around 40,000 users on my site but around 20,000 of them are automated registrations (by comment spammers presumably) and I'd like to delete those.

It's very easy to spot them as their registration date/time is exactly the same as their last access date/time.

How do I filter the user list in Views so that I only get users whose "member for"=="Last access"?

1 Answer 1


These won't be exact matches. It uses a timestamp value that will vary, even if only a few seconds.

I would suggest doing this in some custom PHP

that module, or writing your own custom functions. you'd convert the timestamp difference to a reasonable value (say, within 1 hour?) and then user_delete()

I would also add a captcha and/or email verification to help prevent this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.