I have a local instance of a DNN portal v4.06.02 where I need to run a database script to delete a huge chunk of the users.  Looking through the DNN source, I know that I need to delete the users in a specific way and order.  I have that order below.

That part is easy enough in theory. It is pretty obvious where and how to delete the objects in the first two steps. However, the deletion of the membership user is not as straightforward.  It requires the Application Name.  I can see in the aspnet_Applications table what the application name is, but that would force me to hard-code it.  What I need to do is figure out where the data join is made between the DNN data and the aspnet provider data.

Additionally, what is an appropriate value for the @TablesToDeleteFrom argument?

Will, I've done this in the past to delete a large number of users:

1. Run this SQL: Update UserPortals set Authorised=0 where UserId in [... select whichever users you want to delete ... ]

2. Go to Admin | User Accounts and click the "Delete Unathorized Users" button.  Wait a little bit and they will be all gone.  Let DNN do all the work for you.

JK.

also... i think the asp.net application name is always DotNetNuke

DNN Blog | Twitter: @erikvb | LinkedIn: