We are doing an Integration with Dynamics CRM. I have done a search on a bulk delete too for DNN or an SQL script and I cannot find one. We have about 4000 users and we just want to dump them and then sync our Dynamics CRM Contacts as users for DNN. Does anyone know of a simple way of doing a bulk delete of all users except Super Users?

I used the following statement in the database and it does seem to work. The problem is, when I select Delete Unauthorized users and then select Remove Deleted users, they users do not seemd to be removed from the database. They are removed from the DNN GUI and it does look like all my 4000+ users are gone but when I look at the actual user table all the users are still there. Is that normal?

update UserPortals
Set Authorised='False' where Authorised='True'

I am using the latest version of Professional DNN. There is no bulk delete in the administration interface. That is what I am looking for. I understand the hard delete but I want to dump all users from my portal. There is only one portal.

Right now, you have to click Delete next to each user name. I have over 4000 users to delete. Any ideas?

Do you mean I should be able to do a bulk delete in the "users control panel?" I did not think that was a feature that was available?