Geeks With Blogs

News

 
Subscribe by Email:







Updates:
about

via Twitter


www.flickr.com
This is a Flickr badge showing photos in a set called Public. Make your own badge here.


View Will Pritchard's profile on LinkedIn


View blog authority

MOSS Paradox SharePoint, Microsoft BI, .NET, Microsoft Tech and errata

By default Office SharePoint Server 2007 imports all profiles from the Active Directory Database.  This presents an issue for some companies (mine in particular ;)).  After doing some searching I found an older article by Michael Bollhoefer.

He tipped me off to the following LDAP filter which worked beautifully, and after running a full profile import and reindexing our SharePoint Search those old Inactive profiles were gone from the Database and the search.

(&(objectCategory=person)(objectClass=user)( !(userAccountControl:1.2.840.113556.1.4.803:=2)))

To set your LDAP filter go to Central Administration > SSP > User Profiles and Properties > View import connections.  Edit your Connection and insert the User Filter as shown above. Click ok and run a full import.

Now you can switch over to your Microsoft SQL Server Management Studio and run the following query on your SharedServices Database:

select * from UserProfile_Full
where bDeleted = 1

You should see all of your Inactive users listed. Once the import is finished you can run the query again and you should return 0 results. The filter will also remove any rows from the dbo.UserProfileValue table as well.

Next, run a full crawl of your Local Office SharePoint Server sites to remove the old profile indexes from the My Sites and anywhere else in your SharePoint sites.



kick it on SharePointKicks.com Posted on Tuesday, July 10, 2007 11:57 AM SharePoint 2007 | Back to top


Comments on this post: Cleaning Inactive Profiles from SharePoint 2007

# re: Cleaning Inactive Profiles from SharePoint 2007
Requesting Gravatar...
All above is true, except for one detail that I am not sure how you managed to do. All sharepoint resources I've seen so far discuss the fact that the profiles are not automatically removed from the profile DB. They are simply added to the view "Profiles Missing from Import" and have to be manually deleted by the administrator. Did you find a standard way to remove the profiles automatically when they are no longer in the AD or disabled?
Left by Thomas Glod on Aug 08, 2007 6:57 AM

# re: Cleaning Inactive Profiles from SharePoint 2007
Requesting Gravatar...
Thanks for the link love. If you have any more questions about it, drop me a line!
Left by Michael Bollhoefer on Nov 13, 2007 3:03 PM

# re: Cleaning Inactive Profiles from SharePoint 2007
Requesting Gravatar...
Nice article....but i m getting problem.
Still people are coming in search.
Left by Tariq Younas on Apr 25, 2008 6:02 AM

# re: Cleaning Inactive Profiles from SharePoint 2007
Requesting Gravatar...
Nice explanation...but i have prblm.

I am still getting those deleted users in people search.
Left by Tariq Younas on Apr 25, 2008 6:03 AM

# re: Cleaning Inactive Profiles from SharePoint 2007
Requesting Gravatar...
The filter should read more like this (w/the =2):

(&(objectClass=user)(!userAccountControl:1.2.840.113556.1.4.803:=2))
Left by fw on Nov 01, 2010 6:35 AM

Your comment:
 (will show your gravatar)


Copyright © Will Pritchard | Powered by: GeeksWithBlogs.net