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 629 posts 1016 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 4045 posts 12898 karma points MVP 2x
    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 629 posts 1016 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 4045 posts 12898 karma points MVP 2x
    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
Please Sign in or register to post replies

Write your reply to:

Draft