How to clean the Contacts and relevant Users

Question

Though I use Captcha and reCaptcha, I have a lot of dummy users and Contacts which I can identify by the fact that their sort_name = display_name = email (or sort_name contains an "@").

How can I delete those Users and Contacts ?

My original idea was to create a Dynamic Group of those, then delete them after exporting their list to excel to delete the relevant Users. But, how to create such a Dynamic Group (based on what search criteria ?) ?

An alternative would be to create a View (filtered on "sort_name contains '@'"), then use VBO to add them to a Group : I tried, but could not succeed).

I tried using the Search Builder, but it is broken : I have openned a new post for that : Search Builder is broken (Civi 5.4.0 / Drupal 7.59)

Answer 1

You could use Search > Search Builder and search for Individuals whose First Name and Last Name are NULL (when this is the case, Civi will use the email address as the Display Name), select all of the search results and then create a Smart Group. You would then periodically review the contacts of the smart group by navigating to Contacts > Manage Groups and then clicking on the Contacts hyperlink to the right-hand side of the group and perform the desired actions.

Answer 2

You can use Search Builder to make Smart Group for contacts where Sort Name like @ and First Name null

Name or Email LIKE - '%@%' ...AND... First Name Is Null ...AND... Contact Type = Individual

But I would then use VBO myself so that you can delete any Drupal users that are orphaned (ie no longer have a related civi contact)

We built a View to do this which I can fire through to you if you have trouble creating it from scratch. Ping me in redmine (gratis)