Announcement

Collapse
No announcement yet.

prune 100k user

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • prune 100k user

    i need to prune about lot of my users. i have tried using prune/move user function in acp but the result is very big to display about 100k users.

    can you please help me with direct sql to complete this task?
    the conditions are "has not logged on for 365 days" and "0 post".

    Thanks and regards

  • #2
    You have 100k of users that have 0 (zero) post and have not been active for 365 days?

    Comment


    • #3
      it's typo actually it's 10k

      anyone ????

      Comment


      • #4
        I recommend you set your search criteria to result in a smaller number of matching users. Then relax your search criteria from there to process them in batches.

        Comment

        Loading...
        Working...
        X