I don't come from a heavy SharePoint background so please don't judge :)
I wanted to know if there was a query I can run to delete numerous duplicate User Profiles from the Profile DB. I recently migrated SharePoint 2010 to 2013; previous SharePoint admins have played around with the UPA because it wasn't working correctly and somehow duplicate profiles were shown up. I have the My Site clean up timer job running daily but it doesn't seem to clean up these profiles in the actual DB. I'm running SQL 2012 Standard on SharePoint 2013 Enterprise.
To give you an example, my boss has 5 user profiles in the DB table listed. Only one of the records have most of the columns populated with info but the others look incomplete.
Any help would be appreciated!
@Waqas, I can't comment on your link but I tried that. Do you know of a command that would grab only some of the users on this list? Some users on this list are still active users