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.
- Run full profile import three times back to back. Make sure it finishes with out any error.
- After that you will find users in view user profile > Profile Missing from import.
- You can manually delete these unwanted profile or wait till clean up job delete them.