SharePoint Server 2007 Profile Properties and their default Active Directory mappings
A couple of weeks ago a question was raised about which profile properties available in SharePoint Profile Database are mapped through to Active Directory and what fields they relate to. After some digging around and not finding a great deal on the subject I thought Iw ould knock together a quick post detailing them.
The user Profile Database in SharePoint is a great way of utilising existing user information in other systems across a SharePoint Farm. The Profile Database is part of the Shared Services Provider (SSP) which provides data and services for all the sites across SharePoint Farm. If user information is stored within another system it would be a waste of time and resources to create all the data again in SharePoint. This data so it can be imported from another directory or system and stored centrally in SharePoint and shared across the environment. One source that is available for organisations to use is their Active Directory environment. If the details about a user are populated within AD these can be pulled through when an profile import occurs.
Once a SSP has been created and the directory source configured for the Profile Database, SharePoint maps certain pieces of information that resides within an AD schema into the Profiles Database. Which ones are they though? Below is a table that references each of the properties in AD and how they are mapped through to the profiles Database.
Property Name |
Mapped Attribute/AD Internal Property |
AD Display Name |
AD Property Tab |
SID |
objectSID |
Generated on object creation |
N/A |
Active Directory Id |
objectGuid |
Generated on Object Create |
N/A |
Account name |
<Specific to connection> |
User logon Name |
Account |
First name |
givenName |
First Name |
General |
Last name |
sn |
Last Name |
General |
Name |
displayName |
Display Name |
General |
Work phone |
telephoneNumber |
Telephone Number |
General |
Office |
physicalDeliveryOfficeName |
Office |
General |
Department |
department |
Department |
Organisation |
Title |
title |
Job Title |
Organisation |
Manager |
manager |
Manager > Name |
Organisation |
User name |
samAccountName |
Generated on account creation based on users name |
General |
Public site redirect |
wWWHomePage |
Web Page |
General |
SIP Address |
msRTCSIP-PrimaryUserAddress |
Available when OCS is installed within a domain |
N/A |
Proxy addresses |
proxyAddresses |
Available when Exchange is installed within a domain |
N/A |
Master Account Name |
msDS-SourceObjectDN |
Avaialble when OCS is installed within a domain |
N/A |
Work e-mail |
General |
There are also other properties available within the profiles database as well. These can be viewed by going to the following steps:
- Select the Shared Service Provider
- Select the User profiles and properties under the User Profiles and My Sites section
- Select View profile properties under the User Profile Properties section.
![rob_finney[1]](https://msdntnarchive.blob.core.windows.net/media/TNBlogsFS/BlogFileStorage/blogs_msdn/uksharepoint/WindowsLiveWriter/QuicktipADPropertiesmappedtoSharePointPr_BEF6/rob_finney%5B1%5D.png "rob_finney[1]")
Rob Finney
Consultant
Microsoft Consulting Services UK
robert.finney@Microsoft.com