AD Properties can be mapped to user property

SharePoint administrator can add a new user profile property, which can be mapped to an AD attribute. For example, user profile property “First Name” is mapped to “givenName” in AD which is a “string (Single Value)” type:

1

If you want to add a new user profile, go into the Add User Profile Property page by clicking “New Property” list. A new property type must be specified first:

1

After specifying the property type, the AD attributes will be filtered based on the type. For example, if the “date” type is selected then the AD attributes will show like this:

3

All AD attributes which can be mapped as date will be listed.

[expand title=”AD attributes which can be mapped as a string (Single Value), URL, float, HTML, email Total: 212″ tag=”strong”]

aCSPolicyName
adminDescription
adminDisplayName
autoReplyMessage
brandonTestAttibute
c
cn
co
comment
company
department
desktopProfile
displayName
displayNamePrintable
division
dnQualifier
employeeID
employeeNumber
employeeType
extensionAttribute1
extensionAttribute10
extensionAttribute11
extensionAttribute12
extensionAttribute13
extensionAttribute14
extensionAttribute15
extensionAttribute2
extensionAttribute3
extensionAttribute4
extensionAttribute5
extensionAttribute6
extensionAttribute7
extensionAttribute8
extensionAttribute9
facsimileTelephoneNumber
folderPathname
forwardingAddress
gecos
generationQualifier
givenName
homeDirectory
homeDrive
homePhone
homePostalAddress
importedFrom
info
initials
ipPhone
l
language
legacyExchangeDN
loginShell
mail
mailNickname
middleName
mobile
msDS-LastKnownRDN
msDS-PhoneticCompanyName
msDS-PhoneticDepartment
msDS-PhoneticDisplayName
msDS-PhoneticFirstName
msDS-PhoneticLastName
msDS-PrincipalName
msDS-SourceObjectDN
msExchArchiveAddress
msExchArchiveRelease
msExchAssistantName
msExchConfigurationXML
msExchDefaultPublicFolderMailbox
msExchDirsyncID
msExchDirsyncSourceObjectClass
msExchExpansionServerName
msExchExtensionAttribute16
msExchExtensionAttribute17
msExchExtensionAttribute18
msExchExtensionAttribute19
msExchExtensionAttribute20
msExchExtensionAttribute21
msExchExtensionAttribute22
msExchExtensionAttribute23
msExchExtensionAttribute24
msExchExtensionAttribute25
msExchExtensionAttribute26
msExchExtensionAttribute27
msExchExtensionAttribute28
msExchExtensionAttribute29
msExchExtensionAttribute30
msExchExtensionAttribute31
msExchExtensionAttribute32
msExchExtensionAttribute33
msExchExtensionAttribute34
msExchExtensionAttribute35
msExchExtensionAttribute36
msExchExtensionAttribute37
msExchExtensionAttribute38
msExchExtensionAttribute39
msExchExtensionAttribute40
msExchExtensionAttribute41
msExchExtensionAttribute42
msExchExtensionAttribute43
msExchExtensionAttribute44
msExchExtensionAttribute45
msExchExternalDirectoryObjectId
msExchExternalSyncState
msExchFBURL
msExchGenericForwardingAddress
msExchHomeServerName
msExchHouseIdentifier
msExchIMAddress
msExchIMAPOWAURLPrefixOverride
msExchIMMetaPhysicalURL
msExchImmutableId
msExchIMPhysicalURL
msExchLicenseToken
msExchLitigationHoldOwner
msExchMailboxMoveBatchName
msExchMailboxMoveRemoteHostName
msExchMailboxPlanType
msExchMailboxRelease
msExchMailboxUrl
msExchPartnerGroupID
msExchPfRootUrl
msExchPublicFolderSmtpAddress
msExchResourceDisplay
msExchRetentionComment
msExchRetentionURL
msExchShadowAssistantName
msExchShadowC
msExchShadowCo
msExchShadowCompany
msExchShadowDepartment
msExchShadowDisplayName
msExchShadowFacsimileTelephoneNumber
msExchShadowGivenName
msExchShadowHomePhone
msExchShadowInfo
msExchShadowInitials
msExchShadowL
msExchShadowMailNickname
msExchShadowMobile
msExchShadowPager
msExchShadowPhysicalDeliveryOfficeName
msExchShadowPostalCode
msExchShadowSn
msExchShadowSt
msExchShadowStreetAddress
msExchShadowTelephoneAssistant
msExchShadowTelephoneNumber
msExchShadowTitle
msExchShadowWindowsLiveID
msExchShadowWWWHomePage
msExchTeamMailboxSharePointUrl
msExchUMFaxId
msExchUMOperatorNumber
msExchUMPhoneProvider
msExchUsageLocation
msExchUserCulture
msExchVoiceMailboxID
msExchWindowsLiveID
msIIS-FTPDir
msIIS-FTPRoot
msRADIUSCallbackNumber
msRADIUS-FramedInterfaceId
msRADIUS-FramedIpv6Prefix
msRADIUS-SavedFramedInterfaceId
msRADIUS-SavedFramedIpv6Prefix
msRASSavedCallbackNumber
msSFU30Name
msSFU30NisDomain
msTSHomeDirectory
msTSHomeDrive
msTSInitialProgram
msTSLicenseVersion
msTSLicenseVersion2
msTSLicenseVersion3
msTSLicenseVersion4
msTSManagingLS
msTSManagingLS2
msTSManagingLS3
msTSManagingLS4
msTSProfilePath
msTSWorkDirectory
name
pager
personalPager
personalTitle
physicalDeliveryOfficeName
pOPCharacterSet
pOPContentFormat
postalCode
preferredLanguage
primaryInternationalISDNNumber
primaryTelexNumber
profilePath
sAMAccountName
scriptPath
sn
st
street
streetAddress
targetAddress
telephoneAssistant
telephoneNumber
textEncodedORAddress
title
unicodePwd
unixHomeDirectory
userParameters
userPrincipalName
userSharedFolder
userWorkstations
wWWHomePage

[/expand]
[expand title=”AD attributes which can be mapped as a string (Multi Value) Total:91″ tag=”strong”]

accountNameHistory
altSecurityIdentities
businessCategory
carLicense
departmentNumber
description
destinationIndicator
extensionName
groupPriority
groupsToIgnore
houseIdentifier
internationalISDNNumber
labeledURI
mhsORAddress
msDS-AllowedToDelegateTo
msExchADCGlobalNames
msExchAggregationSubscriptionCredential
msExchAlternateMailboxes
msExchArchiveName
msExchCustomProxyAddresses
msExchDirsyncAuthorityMetadata
msExchDirsyncStatusAck
msExchEdgeSyncCookies
msExchEwsExceptions
msExchEwsWellKnownApplicationPolicies
msExchExtensionCustomAttribute1
msExchExtensionCustomAttribute2
msExchExtensionCustomAttribute3
msExchExtensionCustomAttribute4
msExchExtensionCustomAttribute5
msExchLabeledURI
msExchMobileAllowedDeviceIDs
msExchMobileBlockedDeviceIDs
msExchObjectCountQuota
msExchOmaAdminExtendedSettings
msExchOriginatingForest
msExchPoliciesExcluded
msExchPoliciesIncluded
msExchProxyCustomProxy
msExchRecipientValidatorCookies
msExchResourceGUID
msExchResourceMetaData
msExchResourceProperties
msExchResourceSearchProperties
msExchSendAsAddresses
msExchSenderHintTranslations
msExchShadowOtherFacsimileTelephone
msExchShadowOtherHomePhone
msExchShadowOtherTelephone
msExchShadowProxyAddresses
msExchSharingAnonymousIdentities
msExchSharingPartnerIdentities
msExchSignupAddresses
msExchUCVoiceMailSettings
msExchUMAddresses
msExchUMCallingLineIDs
msExchUMDtmfMap
msExchUserHoldPolicies
msNPCallingStationID
msNPSavedCallingStationID
msRADIUS-FramedIpv6Route
msRADIUSFramedRoute
msRADIUS-SavedFramedIpv6Route
msRASSavedFramedRoute
msTSLSProperty01
msTSLSProperty02
msTSProperty01
msTSProperty02
networkAddress
o
otherFacsimileTelephoneNumber
otherHomePhone
otherIpPhone
otherLoginWorkstations
otherMailbox
otherMobile
otherPager
otherTelephone
ou
postalAddress
postOfficeBox
protocolSettings
proxyAddresses
roomNumber
serialNumber
servicePrincipalName
uid
url
userSharedFolderOther
wbemPath
x121Address

[/expand]
[expand title=”AD attributes which can be mapped as an integer, time zone Total:124″ tag=”strong”]

adminCount
codePage
countryCode
deletedItemFlags
delivContLength
deliveryMechanism
dLMemDefault
enabledProtocols
flags
garbageCollPeriod
gidNumber
heuristics
instanceType
internetEncoding
languageCode
mDBOverHardQuotaLimit
mDBOverQuotaLimit
mDBStorageQuota
mS-DS-ConsistencyChildCount
msDS-FailedInteractiveLogonCount
msDS-FailedInteractiveLogonCountAtLastSuccessfulLogon
msDS-HABSeniorityIndex
msDS-NcType
msDS-SecondaryKrbTgtNumber
msDS-SupportedEncryptionTypes
msExchAddressBookFlags
msExchALObjectVersion
msExchArchiveStatus
msExchAuditAdmin
msExchAuditDelegate
msExchAuditDelegateAdmin
msExchAuditOwner
msExchCalendarLoggingQuota
msExchContentConversionSettings
msExchDumpsterQuota
msExchDumpsterWarningQuota
msExchEdgeSyncConfigFlags
msExchEdgeSyncRetryCount
msExchELCMailboxFlags
msExchEwsApplicationAccessPolicy
msExchEwsEnabled
msExchExternalOOFOptions
msExchForestModeFlag
msExchGroupExternalMemberCount
msExchGroupMemberCount
msExchIMAP4Settings
msExchInconsistentState
msExchLocalizationFlags
msExchMailboxAuditLogAgeLimit
msExchMailboxFolderSet
msExchMailboxFolderSet2
msExchMailboxMoveFlags
msExchMailboxMoveStatus
msExchManagementSettings
msExchMaxBlockedSenders
msExchMaxSafeSenders
msExchMDBRulesQuota
msExchMessageHygieneFlags
msExchMessageHygieneSCLDeleteThreshold
msExchMessageHygieneSCLJunkThreshold
msExchMessageHygieneSCLQuarantineThreshold
msExchMessageHygieneSCLRejectThreshold
msExchMobileDebugLogging
msExchMobileMailboxFlags
msExchMobileSettings
msExchModerationFlags
msExchOmaAdminWirelessEnable
msExchOrganizationUpgradeRequest
msExchOrganizationUpgradeStatus
msExchOWASettings
msExchPOP3Settings
msExchProvisioningFlags
msExchRecipientDisplayType
msExchRecipientSoftDeletedStatus
msExchRecipLimit
msExchResourceCapacity
msExchRoleGroupType
msExchSetupStatus
msExchShadowCountryCode
msExchTransportInboundSettings
msExchTransportOutboundSettings
msExchTransportRecipientSettingsFlags
msExchTUISpeed
msExchTUIVolume
msExchUMAudioCodec
msExchUMAudioCodec2
msExchUMEnabledFlags
msExchUMEnabledFlags2
msExchUMListInDirectorySearch
msExchUMMailboxOVALanguage
msExchUMMaxGreetingDuration
msExchUMServerWritableFlags
msExchUserAccountControl
msRADIUSFramedIPAddress
msRADIUSServiceType
msRASSavedFramedIPAddress
msTSMaxConnectionTime
msTSMaxDisconnectionTime
msTSMaxIdleTime
msTSRemoteControl
objectVersion
operatorCount
primaryGroupID
replicatedObjectVersion
replicationSensitivity
revision
rid
sAMAccountType
shadowExpire
shadowFlag
shadowInactive
shadowLastChange
shadowMax
shadowMin
shadowWarning
submissionContLength
systemFlags
uidNumber
userAccountControl
USNIntersite
versionNumber

[/expand]
[expand title=”AD attributes which can be mapped as Unique Identifier, binary Total:54″ tag=”strong”]

businessRoles
dBCSPwd
dSASignature
formData
groupMembershipSAM
logonHours
logonWorkstation
msDS-Cached-Membership
mS-DS-ConsistencyGuid
mS-DS-CreatorSID
msExchArchiveDatabaseLinkSL
msExchArchiveGUID
msExchBlockedSendersHash
msExchCanaryData0
msExchCanaryData1
msExchCanaryData2
msExchCorrelationId
msExchDisabledArchiveDatabaseLinkSL
msExchDisabledArchiveGUID
msExchEdgeSyncSourceGuid
msExchForeignGroupSID
msExchHomeMDBSL
msExchHomeMTASL
msExchMailboxGuid
msExchMailboxMoveSourceArchiveMDBLinkSL
msExchMailboxMoveSourceMDBLinkSL
msExchMailboxMoveTargetArchiveMDBLinkSL
msExchMailboxMoveTargetMDBLinkSL
msExchMasterAccountSid
msExchObjectID
msExchOnPremiseObjectGuid
msExchPreviousAccountSid
msExchPreviousArchiveDatabaseSL
msExchPreviousHomeMDBSL
msExchPreviousMailboxGuid
msExchSafeRecipientsHash
msExchSafeSendersHash
msExchTUIPassword
msExchUMPinChecksum
msExchUMSpokenName
msExchUnmergedAttsPt
mSMQSignCertificates
mSMQSignCertificatesMig
msPKIRoamingTimeStamp
objectGUID
objectSid
replicationSignature
securityIdentifier
supportedAlgorithms
terminalServer
thumbnailLogo
thumbnailPhoto
unmergedAtts
userCert

[/expand]
[expand title=”AD attributes which can be mapped as Person Total:46″ tag=”strong”]

altRecipient
assistant
dynamicLDAPServer
fSMORoleOwner
homeMDB
homeMTA
kMServer
lastKnownParent
manager
msCOM-UserPartitionSetLink
msDS-ResultantPSO
msExchAddressBookPolicyLink
msExchArbitrationMailbox
msExchArchiveDatabaseLink
msExchControllingZone
msExchCU
msExchDisabledArchiveDatabaseLink
msExchHABRootDepartmentLink
msExchIMVirtualServer
msExchIntendedMailboxPlanLink
msExchMailboxMoveSourceArchiveMDBLink
msExchMailboxMoveSourceMDBLink
msExchMailboxMoveTargetArchiveMDBLink
msExchMailboxMoveTargetMDBLink
msExchMailboxTemplateLink
msExchMobileMailboxPolicyLink
msExchOURoot
msExchOWAPolicy
msExchParentPlanLink
msExchPreviousArchiveDatabase
msExchPreviousHomeMDB
msExchPublicFolderMailbox
msExchQueryBaseDN
msExchRBACPolicyLink
msExchServerAssociationLink
msExchShadowManagerLink
msExchSharingPolicyLink
msExchSyncAccountsPolicyDN
msExchTeamMailboxSharePointLinkedBy
msExchThrottlingPolicyDN
msExchUMRecipientDialPlanLink
msExchUMTemplateLink
msExchUseOAB
msTSPrimaryDesktop
objectCategory
preferredOU

[/expand]
[expand title=”AD attributes which can be mapped as date time (date no year, date) Total:22″ tag=”strong”]

birthday
createTimeStamp
expirationTime
msDS-LocalEffectiveDeletionTime
msDS-LocalEffectiveRecycleTime
msExchELCExpirySuspensionEnd
msExchELCExpirySuspensionStart
msExchLastExchangeChangedTime
msExchLitigationHoldDate
msExchMailboxAuditLastAdminAccess
msExchMailboxAuditLastDelegateAccess
msExchMailboxAuditLastExternalAccess
msExchShadowWhenSoftDeletedTime
msExchTeamMailboxExpiration
msExchWhenMailboxCreated
msExchWhenSoftDeletedTime
msTSExpireDate
msTSExpireDate2
msTSExpireDate3
msTSExpireDate4
startDate
whenCreated

[/expand]
[expand title=”AD attributes which can be mapped as boolean Total:25″ tag=”strong”]

autoReply
deliverAndRedirect
isCriticalSystemObject
isDeleted
isRecycled
mAPIRecipient
mDBUseDefaults
msExchBypassAudit
msExchCalculatedTargetAddress
msExchCalendarRepairDisabled
msExchEnableModeration
msExchHideFromAddressLists
msExchInterruptUserOnAuditFailure
msExchIsMSODirsynced
msExchMailboxAuditEnable
msExchPolicyEnabled
msExchRequireAuthToSendTo
msNPAllowDialin
msTSAllowLogon
msTSBrokenConnectionAction
msTSConnectClientDrives
msTSConnectPrinterDrives
msTSDefaultToMainPrinter
msTSReconnectionAction
showInAdvancedViewOnly

[/expand]
[expand title=”AD attributes which can be mapped as big integer Total:141″ tag=”strong”]

accountExpires
adminCount
codePage
countryCode
deletedItemFlags
delivContLength
deliveryMechanism
dLMemDefault
enabledProtocols
flags
garbageCollPeriod
gidNumber
heuristics
instanceType
internetEncoding
languageCode
lastLogonTimestamp
lockoutTime
maxStorage
mDBOverHardQuotaLimit
mDBOverQuotaLimit
mDBStorageQuota
msDS-Cached-Membership-Time-Stamp
mS-DS-ConsistencyChildCount
msDS-FailedInteractiveLogonCount
msDS-FailedInteractiveLogonCountAtLastSuccessfulLogon
msDS-GeoCoordinatesAltitude
msDS-GeoCoordinatesLatitude
msDS-GeoCoordinatesLongitude
msDS-HABSeniorityIndex
msDS-LastFailedInteractiveLogonTime
msDS-LastSuccessfulInteractiveLogonTime
msDS-NcType
msDS-SecondaryKrbTgtNumber
msDS-SupportedEncryptionTypes
msDS-UserPasswordExpiryTimeComputed
msExchAddressBookFlags
msExchALObjectVersion
msExchArchiveQuota
msExchArchiveStatus
msExchArchiveWarnQuota
msExchAuditAdmin
msExchAuditDelegate
msExchAuditDelegateAdmin
msExchAuditOwner
msExchCalendarLoggingQuota
msExchContentConversionSettings
msExchDumpsterQuota
msExchDumpsterWarningQuota
msExchEdgeSyncConfigFlags
msExchEdgeSyncRetryCount
msExchELCMailboxFlags
msExchEwsApplicationAccessPolicy
msExchEwsEnabled
msExchExternalOOFOptions
msExchForestModeFlag
msExchGroupExternalMemberCount
msExchGroupMemberCount
msExchIMAP4Settings
msExchInconsistentState
msExchLocalizationFlags
msExchMailboxAuditLogAgeLimit
msExchMailboxFolderSet
msExchMailboxFolderSet2
msExchMailboxMoveFlags
msExchMailboxMoveStatus
msExchManagementSettings
msExchMaxBlockedSenders
msExchMaxSafeSenders
msExchMDBRulesQuota
msExchMessageHygieneFlags
msExchMessageHygieneSCLDeleteThreshold
msExchMessageHygieneSCLJunkThreshold
msExchMessageHygieneSCLQuarantineThreshold
msExchMessageHygieneSCLRejectThreshold
msExchMobileDebugLogging
msExchMobileMailboxFlags
msExchMobileSettings
msExchModerationFlags
msExchOmaAdminWirelessEnable
msExchOrganizationUpgradeRequest
msExchOrganizationUpgradeStatus
msExchOWASettings
msExchPOP3Settings
msExchPreviousRecipientTypeDetails
msExchProvisioningFlags
msExchRecipientDisplayType
msExchRecipientSoftDeletedStatus
msExchRecipientTypeDetails
msExchRecipLimit
msExchRemoteRecipientType
msExchResourceCapacity
msExchRoleGroupType
msExchSetupStatus
msExchShadowCountryCode
msExchTransportInboundSettings
msExchTransportOutboundSettings
msExchTransportRecipientSettingsFlags
msExchTUISpeed
msExchTUIVolume
msExchUMAudioCodec
msExchUMAudioCodec2
msExchUMEnabledFlags
msExchUMEnabledFlags2
msExchUMListInDirectorySearch
msExchUMMailboxOVALanguage
msExchUMMaxGreetingDuration
msExchUMServerWritableFlags
msExchUserAccountControl
msExchVersion
msRADIUSFramedIPAddress
msRADIUSServiceType
msRASSavedFramedIPAddress
msTSMaxConnectionTime
msTSMaxDisconnectionTime
msTSMaxIdleTime
msTSRemoteControl
objectVersion
operatorCount
primaryGroupID
pwdLastSet
replicatedObjectVersion
replicationSensitivity
revision
rid
sAMAccountType
shadowExpire
shadowFlag
shadowInactive
shadowLastChange
shadowMax
shadowMin
shadowWarning
submissionContLength
systemFlags
uidNumber
userAccountControl
uSNDSALastObjRemoved
USNIntersite
uSNSource
versionNumber

[/expand]