User profile property mappings in SharePoint and Active Directory

The User profile synchronization with AD comes with a build in property mapping. The following page from The TechNet Library describes the profile properties and link to their corresponding directory service attributes:

Default user profile property mappings (SharePoint Server 2010)

User profile property	AD DS attribute
SPS-DistinguishedName	dn
SID	objectSid
Manager	manager
PreferredName	displayName
FirstName	givenName
LastName	sn
SPS-PhoneticDisplayName	msDS-PhoneticDisplayName
SPS-PhoneticFirstName	msDS-PhoneticFirstName
SPS-PhoneticLastName	msDS-PhoneticLastName
WorkPhone	telephoneNumber
WorkEmail	mail
Office	physicalDeliveryOfficeName
SPS-JobTitle	title
Department	department
UserName	sAMAccountName
PublicSiteRedirect	wWWHomePage
SPS-ProxyAddresses	proxyAddresses
SPS-SourceObjectDN	msDS-SourceObjectDN
SPS-ClaimID	<specific to connection>
SPS-ClaimProviderID	<specific to connection>
SPS-ClaimProviderType	<specific to connection>

All user profile properties

The following link lists all the user profile properties with internal name, display name and data type that SharePoint Server 2010 provides by default:

Default user profile properties (SharePoint Server 2010)

Full table at: http://technet.microsoft.com/en-us/library/hh147513.aspx

Verify user data

The Active Directory Users and Computers snap-in

The Active Directory Users and Computers snap-in is often the interface to the user attributes.

Go her to see the mapping of UI labels and AD attribute in the property pages that are displayed by the Active Directory Users and Computers snap-in:

User Object User Interface Mapping

more at: http://msdn.microsoft.com/en-us/library/windows/desktop/ms677980%28v=vs.85%29.aspx

LDAP Browser

When it comes to navigation through the LDAP directory data there is several tools to choose from. My favorite is the LDAP directory browser from Softerra; http://www.ldapbrowser.com/download.htm

It comes free of charge if you only need read-only operations.