Opened 6 months ago

Last modified 6 months ago

#29420 assigned task

Delete inactive users

Reported by: ln5 Owned by: qbi
Priority: Medium Milestone:
Component: Internal Services/Service - trac Version:
Severity: Normal Keywords:
Cc: Actual Points:
Parent ID: Points:
Reviewer: Sponsor:

Description

We have tens of thousands of users, most of them created by bots and never used.

Create a script that queries the db for last login time of all users and removes users that hasn't logged in for a year.

Child Tickets

Change History (3)

comment:2 Changed 6 months ago by arma

If we just delete all the users who haven't logged in in a year, we're going to have weird surprises, like somebody creating a new account under an old name and suddenly having control over "their" old tickets.

So as a slight modification of the original idea: how about if the db query also checks if they have made a ticket and/or a comment, and skips over them if so? I bet that would still take care of most of the unused accounts.

For extra credit, it might then be instructive to look at the accounts with only one ticket-or-comment to their credit -- I wonder how many of these are spammers that got through.

comment:3 Changed 6 months ago by anarcat

seems like a fair way of cleaning things up

(just testing if my recovered trac account actually works ;)

Note: See TracTickets for help on using tickets.