Remove inactive users from WSS 3.0 RRS feed

  • Question

  • Hi All,

    I have a SharePoint environment with proper installation of WSS 3.0 and only Service Packs of MOSS for SSP. I want to remove the Incative users (now totally more than 800 users are present) from my SharePoint site.

    In SP 2010, there is a job called "My Site Cleaning Job" which is scheduled to remove the inactive users. In MOSS 2007, there is option like "User Profiles and My Sites" option where we can filter to remove the inactive users.

    Can anyone help in doing the same in WSS 3.0 environment. There are no options like User Profiles and Properties in SSP, since it is not MOSS environment.

    Any help would be greatly appreciated!


    Maruthu | My Blog

    Thursday, April 12, 2012 11:07 AM

All replies

  • Hi Muruthu,

    You can refer some old threads from technet 


    which says to remove user from All People manually.


    http://sharepointpsscripts.codeplex.com/releases/view/21693 a automated way needs a list of inactive users from AD



    Hope this will help you

    Warm Regards, Pratik Vyas | SharePoint Consultant | http://sharepointpratik.blogspot.com/ | Posting is provided "AS IS" with no warranties, and confers no rights

    • Proposed as answer by Pratik Vyas Tuesday, September 3, 2013 11:24 PM
    • Unproposed as answer by Pratik Vyas Tuesday, September 3, 2013 11:24 PM
    Friday, April 13, 2012 12:40 AM
  • Hi Pratik,

    Thanks for the reply.

    As mentioned in the first link, it is easy to remove the users from the site by manually. But how we will be able to know "Which user is not using the site for longtime" ?

    The codeplez site gives a .ps script which is a powershell script to find the inactive users in the site but I am not sure about running a powershell script in Win Server 2003 environment.

    The third link is not useful in this case, since I have already mentioned in the question, I donot have options for User Profile and Properties option since it is WSS 3.0 and I could see only SSP in the central admin.

    Any help/suggestions will be greatly appreciated.

    Cheers! Maruthu | http://sharepoint-works.blogspot.com

    Monday, April 16, 2012 8:55 AM
  • Hi,

    In MOSS Content Dbs there is a table UserInfo where there is a column iSActiveuser that shows if a user is active or not.

    Check this in your WSS db as well if it is present there or not.

    I hope this will help you out.

    Thanks, Rahul Rashu

    Tuesday, April 17, 2012 3:55 AM
  • Hi Rashu,

    Thanks for the reply.

    I have checked the WSS content DB and I could see UserInfo table in it. Also, I have queried and retrieved the users from it. IsActive column with values 0 and 1 are present (true and false).

    If the value is 0 then the user is In active. I have the checked the users with value 0 and found that

    1. Some users are removed from the AD and hence the value is 0

    2. The Value is 0 for some users who are not using the site for long time but present in the AD

    Is that advisable to remove the users of both the kind ?

    What does this column IsActive specify in particular ?

    Thanks in Advance!

    Cheers! Maruthu | My Blog

    Tuesday, April 17, 2012 6:09 AM