Disabled accounts in AD show up in SharePoint as active profiles

 

If the proper filter is not applied in import connections. It can lead to hundreds of unwanted / disabled profile in ssp database .

Some times due to IT audits we want to get rid of those profiles from SharePoint database.

 

Here are the steps to clean out unwanted profiles from database.

  • At first apply filter (&(objectCategory=person)(objectClass=user)( !(userAccountControl:1.2.840.113556.1.4.803:=2))) to just import active profiles in connection.

a

 

  • Run full profile import three times back to back. Make sure it finishes with out any error.

c

  • After that you will find users in view user profile > Profile Missing from import.

b

  • You can manually delete these unwanted profile or wait till clean up job delete them.