Cleaning up specific user profile properties in SharePoint and avoid indexing them in Search

After you setup SharePoint application and “My Site” then start to import user profile, you might need to cleanup information that was imported or prevent certain properties from being displayed anywhere in your application. This would happen in a scenario where the customer figures out that the information that was stored in and imported from active directory is not updated and you want to avoid displaying incorrect information across your application.

To make sure that such user information are not displayed across the site after being imported, you need to notice that this information is regularly updated and cached in multiple places in SharePoint. Basically…

  • Properties might be used for indexing in People Search
  • Properties for specific users might be cached in user information list

Avoid indexing specific properties

  • Go to user profile service: manage policies
  • Remove the connection from the title and job title fields
  • Make sure the property is optional
  • Make sure that the property is visible only to user manager as shown below
  • Make sure that property is not indexed for search
  • Settings highlighted below in the image


After you configure the properties…

  • After doing the settings and removing connection to active directory, the properties (title/job title) do not get repopulated to empty and retain the old values. Run the following script to ensure that values are cleaned-up properly…. 

$mySiteUrl = “http://sharepoint:77/
$site = Get-SPSite $mySiteUrl
$context = Get-SPServiceContext $site
$profileManager = New-Object Microsoft.Office.Server.UserProfiles.UserProfileManager($context)
$profiles = $profileManager.GetEnumerator()
foreach ($userProfile in $profiles) {
#Get user profile and change the value
          $userProfile[“title”].Value = “”
          $userProfile[“SPS-JobTitle”].Value = “”

  • After you run the script, check the user profiles from the service and make sure that fields are empty.
  • Perform full import to AD.
  • Check the user profiles again from the central administration and make sure that fields are empty.
  • Perform incremental search crawl to drop previously indexed properties

Removing cached user information from User information list

Some information will be cached in the user information list: “/_catalogs/users/simple.aspx”, you need to make sure that information in this list does not hold reference to the user properties that you wish to clean up. Perform the following steps…

  • Run the following scriptto update the cached user profiles

$url = “http://SharePointSite/
$site  = Get-SPSite $url
$list = $site.OpenWeb().SIteUserInfoList
Write-Host “Total Items:” +  $list.items.count
foreach( $item in $list.items)
     if( $item[“Job Title”] )

            write-host $item[“Job Title”];
            $item[“Job Title”] = “”;
            write-host $item[“Job Title”]; 


Leave a Reply

Please log in using one of these methods to post your comment: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.