Skip to content
brucerchapman edited this page Sep 19, 2014 · 1 revision

The DnnBulkUserDelete is a dev tool designed to assist with the cleaning out of large numbers of users from a Dnn Installation. Typically these have been created by a Registration SPAM bot that registers a lot of users with the intention of returning later and updating the user profile with SPAM SEO links.

Blocking the SPAM Registrations and identifying the SPAM users is outside the scope of this tool. The tool is designed to identify 'soft' deleted users and 'hard' delete them. A soft deleted user is one in which the 'IsDeleted' flag is set in the UserPortals table in Dnn. This can either be set by using the 'delete' functionality within the Dnn User Management screen, or by using SQL Script to identify SPAM users and update the IsDeleted flag.

The software is in two pieces:

  • A Services Layer which is installed into the Dnn site as a Library Extension type
  • A Windows application called 'Dnn Bulk User Delete Console' which calls the services layer installed in the targeted Dnn site.

The purpose of this design is to leverage the Dnn APIs for deleting a user properly from the system without leaving broken referential integrity or leaving behind a mess of User Folders. It is also designed to be run from the console on a 'drip feed' so as to not overwhelm the server or database resources. It's not uncommon to need to delete 100,000+ plus users - this cannot be done in a simple batch operation, properly, without overloading the server.

This is a community contribution and not an official DNN Corp project. It's not designed to be end-user friendly and the operator requires knowledge about Dnn Users, User Profiles and User Folder storage. It is, however, presented here on Github in the expectation that others can contribute to this tool and make it work flawlessly for all use cases.

The Extensions Library requires DNN 7.1 as a minimum.

Clone this wiki locally