powered by Jive Software

Removal of idle/seo/spam users with 0 posts


#1

I’d like to delete all standard users (no special roles) which did not login and did not post within the last 31 days. I want to start with the oldest users first.

Any objections?

I use a script to query the REST API to get this list and I’ll use a script to delete these users.

Name
1st Login
Last Login
Profile Upd.
burtoncliff
2005-08-16T09:26:36
2007-11-29T17:37:51
2005-08-16T09:45:01
verafirmansyah
2005-08-03T04:18:23
2007-11-29T17:37:51
2005-08-03T04:18:23
homero74
2005-07-14T21:19:27
2007-11-29T17:37:51
2005-07-14T21:19:27
star
2005-06-27T07:13:30
2008-01-16T09:16:27
2005-06-27T07:14:26
will_2_power
2005-05-25T02:30:47
2007-11-29T17:37:51
2005-05-25T02:45:56
Gian
2005-05-18T17:26:07
2007-11-29T17:37:51
2005-05-18T17:26:08
pau
2005-05-11T12:05:40
2007-11-29T17:37:51
2005-05-11T12:05:41
kitzu
2005-05-02T09:58:11
2007-11-29T17:37:51
2005-05-02T09:58:11
fdiaconescu
2005-04-29T16:03:10
2007-11-29T17:37:51
2005-04-29T16:03:10
sirichard
2005-04-21T06:29:33
2007-11-29T17:37:51
2005-04-21T06:29:33
noise
2005-03-21T01:27:51
2007-11-29T17:37:51
2005-03-21T01:27:51
kckid
2005-03-15T02:26:36
2007-11-29T17:37:51
2005-03-15T02:26:36
simor
2004-12-07T23:09:48
2007-11-29T17:37:51
2004-12-07T23:09:48
mamcard
2004-11-22T00:46:58
2007-11-29T17:37:51
2004-11-22T00:49:44
kman
2004-11-15T20:07:03
2007-11-29T17:37:51
2004-11-15T20:07:03
chiauly
2004-07-13T14:20:57
2008-08-20T16:02:17
2008-08-20T16:02:17
gshapiro
2004-05-27T21:28:38
2008-02-17T03:21:51
2009-01-22T16:16:09
carmen
2004-05-27T20:59:52
2008-08-07T16:05:51
2008-08-07T16:05:51
fekka
2003-05-27T00:47:49
2007-11-29T17:37:51
2003-05-27T00:47:49
scott
2002-12-12T18:03:20
2008-07-24T20:47:04
2008-07-29T00:38:12
bruce
2002-11-05T15:05:02
2007-11-29T17:37:51
2008-09-22T13:32:25
m_khanduri
2002-10-28T09:21:56
2007-12-18T09:20:12
2007-12-18T09:21:27
abulafia
2002-10-11T18:49:43
2008-02-07T20:18:03
2002-10-12T20:41:49
achuka
2002-05-05T11:53:25
2008-02-07T19:04:08
2002-05-05T11:53:25
Ryan
2002-01-30T00:16:19
2008-03-28T14:04:50
2008-03-28T14:05:42
murthy
2002-01-04T00:27:02
2008-04-10T02:54:38
2002-01-04T00:27:02
huihoo
2001-11-05T07:33:59
2008-07-17T11:46:14
2001-11-05T07:33:59
dulbayar
2001-11-04T03:16:39
2008-07-19T00:29:52
2008-07-19T00:31:28
king
2001-09-03T09:09:14
2007-11-29T17:37:51
2001-09-03T09:09:30
djhersh
2001-06-28T18:29:06
2007-11-29T17:37:51
2006-01-30T21:18:27
nmehta
2001-06-28T08:12:36
2007-11-29T17:37:51
2003-11-24T23:20:49
npudream
2001-06-28T08:12:26
2007-11-29T17:37:51
2001-06-28T08:12:26


#2

I thought you wanted to delete users who have not logged in at all. These ones seems to have logged in at least twice? Well, these are old and probably won’t come back, so no objections. But only if they have no content created.


#3

Right, I should also calculate the difference between 1st and last login and respect it unless the users are disabled.

These users above are disabled, so they are save to delete.

I will add these columns to the HTML table.

The last login date was set to 2007-11-29/30 to everyone during an upgrade to SBS or Clearspace as far as I can tell.

I’m not sure about the 2008-* dates. Why would eg dulbayar register in 2001 and visit the community for 7 years without posting a thing?


#4

He can still like/bookmark/share/pm. Or can you tell that he had no activity at all? Btw, disabled also doesn’t mean that much. I had a case when forums user asked to re-enable his older account, which for some reason was disabled. Actually, i wasn’t able to re-enable it, it was going into disable automatically right away. So i had to delete it and let the user create same account anew. So, system sometimes disables accounts for some reason (some span of inactivity maybe) and sometimes it gets buggy and you can’t re-enable them.


#5

You have nice ideas. The content API returns files, polls, blogs, tasks, updates and also favorites (bookmarks).

It should be acceptable to lose the probably non-existent likes/shares/pms of

  • disabled users
  • users who did never login after registration

#6
  • users who did never login after registration
    Without a question.

PMs can still be accessed via inbox/activity. But if a user has only pms (likes/bookmarks, etc. no content viewable by others) and is disabled for x years, i think it is safe to delete it. We should decide on the x though. If a system disables inactive user after 1 year and he only had a few pms and bookmarks this is still an annoyance to him to have to recreate an account a year later. Especially if his name is taken already Maybe x should be 5 years? Less?