The First Name and Last Names of SharePoint Users are not appearing in My Settings from AD. When I look at the User in the User Profile Service > Manage User Profiles, I can see the First & Last Name properties contain the correct data though.
I understand that the UserInfo Table is where the Users Details are stored and it will use those. So I need to remove the user from the Site Collection, then re-add them.
I discovered this from here...
This works when I remove a user from the site collection and re-add them. However, there are only a few users that are named with access where I can remove. Because everyone else enters the site as <domain>\domain users
Do I remove <domain>\domain users from the site collection then re-add it (I can't see how that would remove the users in the InfoTable)
Or... would I delete the Users directly in SQL from the UserInfo Table (doubt it as I understand it's dangerous to edit directly)
Or... detach the database, then re-attach (was hoping not to do this as it's going to affect the users)
Any other suggestions welcomed.