Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mark Roffey 31 posts 184 karma points
    Apr 28, 2021 @ 15:06
    Mark Roffey
    0

    Delete all members via SQL script?

    Has anyone available a SQLscript that deletes all members from a database.

    I've found a few older V7 versions and obviously there are packages out there, but I'm looking to delete them via SQL Script so that I can incorporate it in as part of a deployment package.

    From what I can see the data is in the following tables. Can anyone confirm?

    cmsMember,

    cmsContentNu,

    umbracoNode,

    cmsMember2MemberGroup

    SELECT        cmsMember.nodeId, cmsMember.Email, cmsMember.LoginName, cmsMember.Password, cmsContentNu.nodeId AS Expr1, cmsContentNu.published, cmsContentNu.data, cmsContentNu.rv, umbracoNode.nodeObjectType, 
                             cmsMember2MemberGroup.MemberGroup
    FROM            cmsMember LEFT OUTER JOIN
                             cmsMember2MemberGroup ON cmsMember.nodeId = cmsMember2MemberGroup.Member LEFT OUTER JOIN
                             umbracoNode ON cmsMember.nodeId = umbracoNode.id LEFT OUTER JOIN
                             cmsContentNu ON cmsMember.nodeId = cmsContentNu.nodeId
    
Please Sign in or register to post replies

Write your reply to:

Draft