Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Dan Evans 616 posts 988 karma points
    Jan 13, 2015 @ 12:55
    Dan Evans
    0

    How to bulk delete member groups

    Hi

    I have a need to delete around 1000 member groups from a site. Is there a quick way to do this from the DB? 

    Thanks

    Dan

    Copy Link
  • Richard Soeteman 3875 posts 12037 karma points MVP
    Jan 13, 2015 @ 13:10
    Richard Soeteman
    1

    Hi Dan,

    Might be an interesting case for Bulkmanager but I think this will work 

    SELECT * FROM umbracoNode where nodeObjectType = '366E63B9-880F-4E13-A61C-98069B029728'

    Will give you all membergroups then you only need a way to filter your 1000 groups and delete it from the umbracoNode table.

    As I mentioned earlier I love to have this in Bulkmanager as well. I can add it this afternoon. Might save you some time?

    Best,

    Richard

    Copy Link
  • Dan Evans 616 posts 988 karma points
    Jan 13, 2015 @ 13:14
    Dan Evans
    0

    Hi Richard!

    Thanks for the prompt reply. I've been using your bulk manager all morning deleting 1000s of pages, members and media files - it's been a life saver.

    This would be an excellent addtion so if you can add it this afternoon that would be great.

    Thanks

    Dan

    Copy Link
  • Richard Soeteman 3875 posts 12037 karma points MVP
    Jan 13, 2015 @ 13:19
    Richard Soeteman
    1

    Hi Dan,

    Closing all other work now and I'm on it :) Great to hear it's a life saver :)

    Thanks,

    Richard

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies