Wednesday, April 6, 2011

AD attributes used in standard configuration of People search in Sharepoint

Sharepoint 2010 uses CoreResultsWebPart on People search page in standard Search center. You can control what properties can be shown by this web part using SelectColumns and PropertiesToRetrieve properties (or via web part properties in UI: Display Properties > Fetched Properties). Here you need to specify names of Managed properties (you can find them in Central Administration > Manage Service Applications > Search Service Application > Metadata properties). This properties are mapped on Crawled properties (available on the same page – if you will click appropriate link on top of the page) which are used by Search crawler. There are several categories of Crawled properties. For People search we are interested in People category. Crawled properties from People category are in associated with User Profile Properties (Central Administration > Manage Service Applications > User Profile Service Application > Manage user properties). Some User Profile Properties are in turn mapped to AD attributes (and some are editable by users).

So we have the following mapping chain: Managed property > Crawled property > User profile property > AD attribute. I created a table where summarized all properties and their mappings:

Managed property

Crawled Properties

User Profile Properties

AD attribute

WorkId

-

-

-

UserProfile_GUID

People:UserProfile_GUID(Text)

Id

-

AccountName

People:AccountName(Text)

Account name

sAMAccountName

PreferredName

People:PreferredName(Text)

Name

displayName

YomiDisplayName

People:SPS-PhoneticDisplayName(Text)

Phonetic Display Name

msDS-PhoneticDisplayName

JobTitle

People:SPS-JobTitle(Text), People:Title(Text), ows_JobTitle(Text), ows_Job_x0020_Title(Text)

Job Title

title

Department

People:Department(Text), ows_Department(Text)

Department

department

WorkPhone

People:WorkPhone(Text), ows_WorkPhone(Text), ows_Work_x0020_Phone(Text)

Work phone

telephoneNumber

OfficeNumber

People:Office(Text)

Office

physicalDeliveryOfficeName

PictureURL

ows_PictureURL(Text), People:PictureURL(Text)

Picture

-

HierarchyUrl

People:ProfileHierarchyViewUrl(Text)

-

-

WorkEmail

People:WorkEmail(Text), ows_EMail(Text), ows_EMail_x0020_(Text)

Work e-mail

mail

Path

Basic:11(Text), Basic:9(Text), Web:2(Text)

-

-

HitHighlightedSummary

No mapping

-

-

HitHighlightedProperties

No mapping

-

-

Responsibility

People:SPS-Responsibility(Text)

-

-

Skills

People:SPS-Skills(Text)

Skills

-

SipAddress

People:SPS-SipAddress(Text)

SIP Address

proxyAddresses

Schools

People:SPS-School(Text)

Schools

-

PastProjects

People:SPS-PastProjects(Text)

Past projects

-

Interests

People:SPS-Interests(Text)

Interests

-

OrgNames

People:OrganizationNames(Text), ows_Company(Text)

-

-

OrgUrls

People:OrganizationURLs(Text)

-

-

OrgParentNames

People:OrganizationParentNames(Text)

-

-

OrgParentUrls

People:OrganizationParentURLs(Text)

-

-

Memberships

People:QuickLinks(Text)

Quick links

-

AboutMe

People:AboutMe(Text), ows_Notes(Text)

About me

-

BaseOfficeLocation

People:SPS-Location(Text)

Office location

-

ServiceApplicationID

No mapping

-

-

SocialDistance

No mapping

-

-

As I said you can customize CoreResultsWebPart and use whatever properties you need. But this table may e useful if you need to know what AD attributes are used in standard configuration of People search in Sharepoint 2010.

3 comments:

  1. Thank you, just what I was looking for.
    Any references back to MS technet articles?

    ReplyDelete
  2. Carry2Web,
    I created this table by myself, so not sure that you will find it on technet. You may try to find list of mappings between User profile properties and AD attributes, but not whole table.

    ReplyDelete
  3. Hi, I really found this useful, but one thing I was looking for was missing from this chart...
    I have spent a couple of days figuring it out, so I wanted to post it here for others.

    Managed Property : MobilePhone
    Crawled Property : People:CellPhone, ows_CellPhone, ows_Cell_x0020_Phone
    User Profile Property : CellPhone
    AD Mapping : mobile

    I really hope this helps (I am unsure of the crawled property, but lifted that from technet).

    ReplyDelete