AAD Connect Sync Service Configuration
Legend:
Create
Update
Delete
Documenter Version:
1.16.0602.0
Report Date:
03/06/2016 07:58:26
Target / Pilot Config ():
Contoso\Pilot
Reference / Production Config ():
Contoso\Production
Table of Contents
AAD Connect Sync Service Configuration
Global Settings
contoso.com Connector Configuration
Synchronization Rules
Inbound
0-In from AD - Computer Join
In from AD - Contact Common
In from AD - Contact Join
In from AD - ForeignSecurityPrincipal Join User
In from AD - Group Common
In from AD - Group Exchange
In from AD - Group Join
In from AD - InetOrgPerson AccountEnabled
In from AD - InetOrgPerson Common
In from AD - InetOrgPerson Common from Exchange
In from AD - InetOrgPerson Exchange
In from AD - InetOrgPerson Join
In from AD - User AccountEnabled
In from AD - User Common
In from AD - User Common from Exchange
In from AD - User Exchange
In from AD - User Join
In from AD - Computer Join
Outbound
Out to AD - Contact Exchange Hybrid
Out to AD - Contact Join
Out to AD - Group Exchange Hybrid
Out to AD - Group Join
Out to AD - InetOrgPerson Exchange Hybrid
Out to AD - InetOrgPerson Join
Out to AD - User Exchange Hybrid
Out to AD - User Join
Setting | Value |
Microsoft.AADFilter.ApplicationList | |
Microsoft.AADFilter.AttributeExclusionList | |
Microsoft.DeviceWriteBack.Container | |
Microsoft.DeviceWriteBack.Forest | |
Microsoft.DirectoryExtension.SourceTargetAttributesMap | |
Microsoft.GroupWriteBack.Container | |
Microsoft.GroupWriteBack.Forest | |
Microsoft.OptionalFeature.DeviceWriteBack | False |
Microsoft.OptionalFeature.DeviceWriteUp | True |
Microsoft.OptionalFeature.DirectoryExtension | False |
Microsoft.OptionalFeature.DirectoryExtensionAttributes | |
Microsoft.OptionalFeature.ExportDeletionThreshold | True |
Microsoft.OptionalFeature.ExportDeletionThresholdValue | 500 |
Microsoft.OptionalFeature.FilterAAD | False |
Microsoft.OptionalFeature.GroupFiltering | False |
Microsoft.OptionalFeature.GroupWriteBack | False |
Microsoft.OptionalFeature.HybridExchange | True |
Microsoft.OptionalFeature.PasswordHashSync | True |
Microsoft.OptionalFeature.PasswordWriteback | False |
Microsoft.OptionalFeature.UserWriteBack | False |
Microsoft.SynchronizationOption.AnchorAttribute | objectGUID |
Microsoft.SynchronizationOption.CustomAttribute | |
Microsoft.SynchronizationOption.JoinCriteria | AlwaysProvision |
Microsoft.SynchronizationOption.UPNAttribute | userPrincipalName |
Microsoft.Synchronize.StagingMode | False |
Microsoft.Synchronize.SynchronizationPolicy | Delta |
Microsoft.Synchronize.SynchronizationSchedule | False |
Microsoft.UserWriteBack.Container | |
Microsoft.UserWriteBack.Forest | |
Microsoft.Version.SynchronizationRuleImmutableTag | V1 |
Description |
Setting | Configuration |
Name | 0-In from AD - Computer Join |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | computer |
Metaverse Object Type | device |
Link Type | Provision |
Precedence | 156 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADComputerJoin.001 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | deviceId | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | IIF(BitAnd([userAccountControl],2)=0,True,False) | Expression | | Update |
cloudCreated | CBool(0) | Expression | true | Update |
cloudFiltered | IIF(IsNullOrEmpty([userCertificate]),True,NULL) | Expression | | Update |
deviceId | objectGUID | Direct | | Update |
deviceOSType | operatingSystem | Direct | | Update |
deviceOSVersion | operatingSystemVersion | Direct | | Update |
deviceTrustType | ServerAd | Constant | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
objectSid | objectSid | Direct | | Update |
registeredOwnerReference | mS-DS-CreatorSID | Direct | true | Update |
sourceAnchor | ConvertToBase64([objectGUID]) | Expression | | Update |
sourceObjectType | Computer | Constant | | Update |
userCertificate | userCertificate | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - Contact Common |
Description | Contact object with Exchange schema in Active Directory. |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | contact |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 114 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADContactCommon.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
assistant | assistant | Direct | | Update |
authOrig | authOrig | Direct | | Update |
c | Trim([c]) | Expression | | Update |
cn | cn | Direct | | Update |
co | Trim([co]) | Expression | | Update |
company | Trim([company]) | Expression | | Update |
countryCode | countryCode | Direct | | Update |
department | Trim([department]) | Expression | | Update |
description | IIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448)) | Expression | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
dLMemRejectPerms | dLMemRejectPerms | Direct | | Update |
dLMemSubmitPerms | dLMemSubmitPerms | Direct | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
facsimileTelephoneNumber | Trim([facsimileTelephoneNumber]) | Expression | | Update |
givenName | Trim([givenName]) | Expression | | Update |
homePhone | Trim([homePhone]) | Expression | | Update |
info | Left(Trim([info]),448) | Expression | | Update |
initials | Trim([initials]) | Expression | | Update |
ipPhone | Trim([ipPhone]) | Expression | | Update |
l | Trim([l]) | Expression | | Update |
legacyExchangeDN | IIF(IsPresent([legacyExchangeDN]), [legacyExchangeDN], NULL) | Expression | | Update |
mail | Trim([mail]) | Expression | | Update |
mailNickname | IIF(IsPresent([mailNickname]), [mailNickname], [cn]) | Expression | | Update |
manager | manager | Direct | | Update |
middleName | Trim([middleName]) | Expression | | Update |
mobile | Trim([mobile]) | Expression | | Update |
msDS-HABSeniorityIndex | msDS-HABSeniorityIndex | Direct | | Update |
msDS-PhoneticDisplayName | msDS-PhoneticDisplayName | Direct | | Update |
msExchAssistantName | msExchAssistantName | Direct | | Update |
msExchBlockedSendersHash | msExchBlockedSendersHash | Direct | | Update |
msExchBypassModerationFromDLMembersLink | msExchBypassModerationFromDLMembersLink | Direct | | Update |
msExchBypassModerationLink | msExchBypassModerationLink | Direct | | Update |
msExchHideFromAddressLists | msExchHideFromAddressLists | Direct | | Update |
msExchModeratedByLink | msExchModeratedByLink | Direct | | Update |
msExchModerationFlags | msExchModerationFlags | Direct | | Update |
msExchRecipientDisplayType | msExchRecipientDisplayType | Direct | | Update |
msExchRecipientTypeDetails | msExchRecipientTypeDetails | Direct | | Update |
msExchRequireAuthToSendTo | msExchRequireAuthToSendTo | Direct | | Update |
msExchRetentionComment | msExchRetentionComment | Direct | | Update |
msExchRetentionURL | msExchRetentionURL | Direct | | Update |
msExchSafeRecipientsHash | msExchSafeRecipientsHash | Direct | | Update |
msExchSafeSendersHash | msExchSafeSendersHash | Direct | | Update |
msExchSenderHintTranslations | msExchSenderHintTranslations | Direct | | Update |
otherFacsimileTelephoneNumber | Trim([otherFacsimileTelephoneNumber]) | Expression | | Update |
otherHomePhone | Trim([otherHomePhone]) | Expression | | Update |
otherIpPhone | Trim([otherIpPhone]) | Expression | | Update |
otherMobile | Trim([otherMobile]) | Expression | | Update |
otherPager | Trim([otherPager]) | Expression | | Update |
otherTelephone | Trim([otherTelephone]) | Expression | | Update |
pager | Trim([pager]) | Expression | | Update |
physicalDeliveryOfficeName | Trim([physicalDeliveryOfficeName]) | Expression | | Update |
postalCode | Trim([postalCode]) | Expression | | Update |
postOfficeBox | IIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448)) | Expression | | Update |
proxyAddresses | RemoveDuplicates(Trim(ImportedValue("proxyAddresses"))) | Expression | | Update |
publicDelegates | publicDelegates | Direct | | Update |
sn | Trim([sn]) | Expression | | Update |
sourceAnchor | ConvertToBase64([objectGUID]) | Expression | | Update |
sourceAnchorBinary | objectGUID | Direct | | Update |
sourceObjectType | Contact | Constant | | Update |
st | Trim([st]) | Expression | | Update |
streetAddress | Trim([streetAddress]) | Expression | | Update |
targetAddress | targetAddress | Direct | | Update |
telephoneAssistant | Trim([telephoneAssistant]) | Expression | | Update |
telephoneNumber | Trim([telephoneNumber]) | Expression | | Update |
thumbnailPhoto | thumbnailPhoto | Direct | | Update |
title | Trim([title]) | Expression | | Update |
unauthOrig | unauthOrig | Direct | | Update |
url | IIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448)) | Expression | | Update |
userCertificate | userCertificate | Direct | | Update |
userSMIMECertificate | userSMIMECertificate | Direct | | Update |
wWWHomePage | Trim([wWWHomePage]) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - Contact Join |
Description | Contact object with default Active Directory schema. |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | contact |
Metaverse Object Type | person |
Link Type | Provision |
Precedence | 113 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADContactJoin.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | mail | mail | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
cloudFiltered | IIF(IsPresent([isCriticalSystemObject]) || ( (InStr([displayName], "(MSOL)") > 0) && (CBool([msExchHideFromAddressLists]))) || (Left([mailNickname], 4) = "CAS_" && (InStr([mailNickname], "}") > 0)) || CBool(InStr(DNComponent(CRef([dn]),1),"\\0ACNF:")>0), True, NULL) | Expression | | Update |
mailEnabled | IIF(( (IsPresent([proxyAddresses]) = True) && (Contains([proxyAddresses], "SMTP:") > 0) && (InStr(Item([proxyAddresses], Contains([proxyAddresses], "SMTP:")), "@") > 0)) || (IsPresent([mail]) = True && (InStr([mail], "@") > 0)), True, False) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - ForeignSecurityPrincipal Join User |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | foreignSecurityPrincipal |
Metaverse Object Type | * |
Link Type | Join |
Precedence | 115 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADForeignSecurityPrincipalJoinUser.001 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | cn | objectSidString | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
- | - | - | - | - |
Description |
Setting | Configuration |
Name | In from AD - Group Common |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | group |
Metaverse Object Type | group |
Link Type | Join |
Precedence | 112 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADGroupCommon.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | isCriticalSystemObject | NOTEQUAL | True |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
cn | cn | Direct | | Update |
description | IIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448)) | Expression | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
info | Left(Trim([info]),448) | Expression | | Update |
mail | Trim([mail]) | Expression | | Update |
managedBy | managedBy | Direct | | Update |
member | member | Direct | | Update |
memberCount | ValueCount("member") | Expression | | Update |
objectSid | objectSid | Direct | | Update |
objectSidString | StringFromSid([objectSid]) | Expression | | Update |
proxyAddresses | RemoveDuplicates(Trim(ImportedValue("proxyAddresses"))) | Expression | | Update |
securityEnabled | CBool(BitAnd([groupType],-2147483648)) | Expression | | Update |
sourceAnchor | ConvertToBase64([objectGUID]) | Expression | | Update |
sourceAnchorBinary | objectGUID | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - Group Exchange |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | group |
Metaverse Object Type | group |
Link Type | Join |
Precedence | 111 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADGroupExchange.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
authOrig | authOrig | Direct | | Update |
dLMemRejectPerms | dLMemRejectPerms | Direct | | Update |
dLMemSubmitPerms | dLMemSubmitPerms | Direct | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
hideDLMembership | hideDLMembership | Direct | | Update |
legacyExchangeDN | legacyExchangeDN | Direct | | Update |
mailNickname | mailNickname | Direct | | Update |
msDS-PhoneticDisplayName | msDS-PhoneticDisplayName | Direct | | Update |
msExchBypassModerationFromDLMembersLink | msExchBypassModerationFromDLMembersLink | Direct | | Update |
msExchBypassModerationLink | msExchBypassModerationLink | Direct | | Update |
msExchCoManagedByLink | msExchCoManagedByLink | Direct | | Update |
msExchEnableModeration | msExchEnableModeration | Direct | | Update |
msExchGroupDepartRestriction | msExchGroupDepartRestriction | Direct | | Update |
msExchGroupJoinRestriction | msExchGroupJoinRestriction | Direct | | Update |
msExchHideFromAddressLists | msExchHideFromAddressLists | Direct | | Update |
msExchModeratedByLink | msExchModeratedByLink | Direct | | Update |
msExchModerationFlags | msExchModerationFlags | Direct | | Update |
msExchRecipientDisplayType | msExchRecipientDisplayType | Direct | | Update |
msExchRecipientTypeDetails | msExchRecipientTypeDetails | Direct | | Update |
msExchRequireAuthToSendTo | msExchRequireAuthToSendTo | Direct | | Update |
msExchRetentionComment | msExchRetentionComment | Direct | | Update |
msExchRetentionURL | msExchRetentionURL | Direct | | Update |
msExchSenderHintTranslations | msExchSenderHintTranslations | Direct | | Update |
oOFReplyToOriginator | oOFReplyToOriginator | Direct | | Update |
publicDelegates | publicDelegates | Direct | | Update |
reportToOriginator | reportToOriginator | Direct | | Update |
reportToOwner | reportToOwner | Direct | | Update |
unauthOrig | unauthOrig | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - Group Join |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | group |
Metaverse Object Type | group |
Link Type | Provision |
Precedence | 110 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADGroupJoin.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | isCriticalSystemObject | NOTEQUAL | True |
1 | adminDescription | NOTSTARTSWITH | Group_ |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | sourceAnchorBinary | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
cloudFiltered | IIF(IsPresent([isCriticalSystemObject]) || [sAMAccountName] = "MSOL_AD_Sync_RichCoexistence" || CBool(IIF(IsPresent([msExchRecipientTypeDetails]),BitAnd([msExchRecipientTypeDetails],&H40000000) > 0,NULL)) || CBool(InStr(DNComponent(CRef([dn]),1),"\\0ACNF:")>0), True, NULL) | Expression | | Update |
mailEnabled | IIF(( (IsPresent([proxyAddresses]) = True) && (Contains([proxyAddresses], "SMTP:") > 0) && (InStr(Item([proxyAddresses], Contains([proxyAddresses], "SMTP:")), "@") > 0)) || (IsPresent([mail]) = True && (InStr([mail], "@") > 0)), True, False) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - InetOrgPerson AccountEnabled |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 103 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADInetOrgPersonAccountEnabled.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | userAccountControl | ISBITNOTSET | 2 |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | True | Constant | | Update |
cn | cn | Direct | | Update |
contributingConnectorUser | %Connector.ID% | Expression | | Update |
domainFQDN | %Domain.FQDN% | Expression | | Update |
domainNetBios | %Domain.Netbios% | Expression | | Update |
forestFQDN | %Forest.FQDN% | Expression | | Update |
forestNetBios | %Forest.Netbios% | Expression | | Update |
objectSid | objectSid | Direct | | Update |
objectSidString | StringFromSid([objectSid]) | Expression | | Update |
pwdLastSet | IIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL) | Expression | | Update |
sourceAnchor | IIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))) | Expression | | Update |
userPrincipalName | IIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present"))) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - InetOrgPerson Common |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 107 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADInetOrgPersonCommon.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | IIF(BitAnd([userAccountControl],2)=0,True,False) | Expression | | Update |
accountName | sAMAccountName | Direct | | Update |
assistant | assistant | Direct | | Update |
c | Trim([c]) | Expression | | Update |
cn | cn | Direct | | Update |
co | Trim([co]) | Expression | | Update |
company | Trim([company]) | Expression | | Update |
countryCode | countryCode | Direct | | Update |
department | Trim([department]) | Expression | | Update |
description | IIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448)) | Expression | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
domainFQDN | %Domain.FQDN% | Expression | | Update |
domainNetBios | %Domain.Netbios% | Expression | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
facsimileTelephoneNumber | Trim([facsimileTelephoneNumber]) | Expression | | Update |
forestFQDN | %Forest.FQDN% | Expression | | Update |
forestNetBios | %Forest.Netbios% | Expression | | Update |
givenName | Trim([givenName]) | Expression | | Update |
homePhone | Trim([homePhone]) | Expression | | Update |
info | Left(Trim([info]),448) | Expression | | Update |
initials | Trim([initials]) | Expression | | Update |
ipPhone | Trim([ipPhone]) | Expression | | Update |
l | Trim([l]) | Expression | | Update |
mail | Trim([mail]) | Expression | | Update |
manager | manager | Direct | | Update |
middleName | Trim([middleName]) | Expression | | Update |
mobile | Trim([mobile]) | Expression | | Update |
objectSid | objectSid | Direct | | Update |
objectSidString | StringFromSid([objectSid]) | Expression | | Update |
otherFacsimileTelephoneNumber | Trim([otherFacsimileTelephoneNumber]) | Expression | | Update |
otherHomePhone | Trim([otherHomePhone]) | Expression | | Update |
otherIpPhone | Trim([otherIpPhone]) | Expression | | Update |
otherMobile | Trim([otherMobile]) | Expression | | Update |
otherPager | Trim([otherPager]) | Expression | | Update |
otherTelephone | Trim([otherTelephone]) | Expression | | Update |
pager | Trim([pager]) | Expression | | Update |
photo | photo | Direct | | Update |
physicalDeliveryOfficeName | Trim([physicalDeliveryOfficeName]) | Expression | | Update |
postalCode | Trim([postalCode]) | Expression | | Update |
postOfficeBox | IIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448)) | Expression | | Update |
preferredLanguage | Trim([preferredLanguage]) | Expression | | Update |
pwdLastSet | IIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL) | Expression | | Update |
sn | Trim([sn]) | Expression | | Update |
sourceAnchor | IIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))) | Expression | | Update |
sourceObjectType | IIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User") | Expression | | Update |
st | Trim([st]) | Expression | | Update |
streetAddress | Trim([streetAddress]) | Expression | | Update |
telephoneNumber | Trim([telephoneNumber]) | Expression | | Update |
thumbnailPhoto | thumbnailPhoto | Direct | | Update |
title | Trim([title]) | Expression | | Update |
url | IIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448)) | Expression | | Update |
userPrincipalName | IIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present"))) | Expression | | Update |
wWWHomePage | Trim([wWWHomePage]) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - InetOrgPerson Common from Exchange |
Description | Attributes from the forest where the InetOrgPerson has an Exchange mailbox. |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 105 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADInetOrgPersonCommonfromExchange.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | mailNickname | ISNOTNULL | |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | IIF(BitAnd([userAccountControl],2)=0,True,False) | Expression | | Update |
accountName | sAMAccountName | Direct | | Update |
assistant | assistant | Direct | | Update |
c | Trim([c]) | Expression | | Update |
cn | cn | Direct | | Update |
co | Trim([co]) | Expression | | Update |
company | Trim([company]) | Expression | | Update |
countryCode | countryCode | Direct | | Update |
department | Trim([department]) | Expression | | Update |
description | IIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448)) | Expression | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
facsimileTelephoneNumber | Trim([facsimileTelephoneNumber]) | Expression | | Update |
givenName | Trim([givenName]) | Expression | | Update |
homePhone | Trim([homePhone]) | Expression | | Update |
info | Left(Trim([info]),448) | Expression | | Update |
initials | Trim([initials]) | Expression | | Update |
ipPhone | Trim([ipPhone]) | Expression | | Update |
l | Trim([l]) | Expression | | Update |
mail | Trim([mail]) | Expression | | Update |
manager | manager | Direct | | Update |
middleName | Trim([middleName]) | Expression | | Update |
mobile | Trim([mobile]) | Expression | | Update |
otherFacsimileTelephoneNumber | Trim([otherFacsimileTelephoneNumber]) | Expression | | Update |
otherHomePhone | Trim([otherHomePhone]) | Expression | | Update |
otherIpPhone | Trim([otherIpPhone]) | Expression | | Update |
otherMobile | Trim([otherMobile]) | Expression | | Update |
otherPager | Trim([otherPager]) | Expression | | Update |
otherTelephone | Trim([otherTelephone]) | Expression | | Update |
pager | Trim([pager]) | Expression | | Update |
photo | photo | Direct | | Update |
physicalDeliveryOfficeName | Trim([physicalDeliveryOfficeName]) | Expression | | Update |
postalCode | Trim([postalCode]) | Expression | | Update |
postOfficeBox | IIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448)) | Expression | | Update |
preferredLanguage | Trim([preferredLanguage]) | Expression | | Update |
proxyAddresses | RemoveDuplicates(Trim(ImportedValue("proxyAddresses"))) | Expression | | Update |
sn | Trim([sn]) | Expression | | Update |
sourceObjectType | IIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User") | Expression | | Update |
st | Trim([st]) | Expression | | Update |
streetAddress | Trim([streetAddress]) | Expression | | Update |
telephoneNumber | Trim([telephoneNumber]) | Expression | | Update |
thumbnailPhoto | thumbnailPhoto | Direct | | Update |
title | Trim([title]) | Expression | | Update |
url | IIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448)) | Expression | | Update |
wWWHomePage | Trim([wWWHomePage]) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - InetOrgPerson Exchange |
Description | InetOrgPerson object with Exchange schema in Active Directory. |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 109 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADInetOrgPersonExchange.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | mailNickname | ISNOTNULL | |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
authOrig | authOrig | Direct | | Update |
contributingConnectorExchange | %Connector.ID% | Expression | | Update |
dLMemRejectPerms | dLMemRejectPerms | Direct | | Update |
dLMemSubmitPerms | dLMemSubmitPerms | Direct | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
legacyExchangeDN | legacyExchangeDN | Direct | | Update |
mailNickname | mailNickname | Direct | | Update |
msDS-HABSeniorityIndex | msDS-HABSeniorityIndex | Direct | | Update |
msDS-PhoneticDisplayName | msDS-PhoneticDisplayName | Direct | | Update |
msExchArchiveGUID | msExchArchiveGUID | Direct | | Update |
msExchArchiveName | msExchArchiveName | Direct | | Update |
msExchAssistantName | msExchAssistantName | Direct | | Update |
msExchBlockedSendersHash | msExchBlockedSendersHash | Direct | | Update |
msExchBypassModerationFromDLMembersLink | msExchBypassModerationFromDLMembersBL | Direct | | Update |
msExchBypassModerationLink | msExchBypassModerationLink | Direct | | Update |
msExchDelegateListLink | msExchDelegateListLink | Direct | | Update |
msExchELCExpirySuspensionEnd | msExchELCExpirySuspensionEnd | Direct | | Update |
msExchELCExpirySuspensionStart | msExchELCExpirySuspensionStart | Direct | | Update |
msExchELCMailboxFlags | msExchELCMailboxFlags | Direct | | Update |
msExchEnableModeration | msExchEnableModeration | Direct | | Update |
msExchHideFromAddressLists | msExchHideFromAddressLists | Direct | | Update |
msExchImmutableId | msExchImmutableId | Direct | | Update |
msExchMailboxGuid | msExchMailboxGuid | Direct | | Update |
msExchMasterAccountSid | msExchMasterAccountSid | Direct | | Update |
msExchModeratedByLink | msExchModeratedByLink | Direct | | Update |
msExchModerationFlags | msExchModerationFlags | Direct | | Update |
msExchRecipientDisplayType | msExchRecipientDisplayType | Direct | | Update |
msExchRecipientTypeDetails | msExchRecipientTypeDetails | Direct | | Update |
msExchRequireAuthToSendTo | msExchRequireAuthToSendTo | Direct | | Update |
msExchResourceCapacity | msExchResourceCapacity | Direct | | Update |
msExchResourceDisplay | msExchResourceDisplay | Direct | | Update |
msExchResourceMetaData | msExchResourceMetaData | Direct | | Update |
msExchResourceSearchProperties | msExchResourceSearchProperties | Direct | | Update |
msExchRetentionComment | msExchRetentionComment | Direct | | Update |
msExchRetentionURL | msExchRetentionURL | Direct | | Update |
msExchSafeRecipientsHash | msExchSafeRecipientsHash | Direct | | Update |
msExchSafeSendersHash | msExchSafeSendersHash | Direct | | Update |
msExchSenderHintTranslations | msExchSenderHintTranslations | Direct | | Update |
publicDelegates | publicDelegates | Direct | | Update |
targetAddress | targetAddress | Direct | | Update |
telephoneAssistant | Trim([telephoneAssistant]) | Expression | | Update |
unauthOrig | unauthOrig | Direct | | Update |
userCertificate | userCertificate | Direct | | Update |
userSMIMECertificate | userSMIMECertificate | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - InetOrgPerson Join |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Provision |
Precedence | 101 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADInetOrgPersonJoin.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | isCriticalSystemObject | NOTEQUAL | TRUE |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | sourceAnchorBinary | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
cloudFiltered | IIF(IsPresent([isCriticalSystemObject]) || IsPresent([sAMAccountName]) = False || [sAMAccountName] = "SUPPORT_388945a0" || Left([mailNickname], 14) = "SystemMailbox{" || Left([sAMAccountName], 4) = "AAD_" || (Left([mailNickname], 4) = "CAS_" && (InStr([mailNickname], "}") > 0)) || (Left([sAMAccountName], 4) = "CAS_" && (InStr([sAMAccountName], "}") > 0)) || Left([sAMAccountName], 5) = "MSOL_" || CBool(IIF(IsPresent([msExchRecipientTypeDetails]),BitAnd([msExchRecipientTypeDetails],&H21C07000) > 0,NULL)) || CBool(InStr(DNComponent(CRef([dn]),1),"\\0ACNF:")>0), True, NULL) | Expression | | Update |
sourceAnchorBinary | objectGUID | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - User AccountEnabled |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 102 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADUserAccountEnabled.004 |
Enable Password Sync | Yes |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | userAccountControl | ISBITNOTSET | 2 |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | True | Constant | | Update |
cn | cn | Direct | | Update |
contributingConnectorUser | %Connector.ID% | Expression | | Update |
domainFQDN | %Domain.FQDN% | Expression | | Update |
domainNetBios | %Domain.Netbios% | Expression | | Update |
forestFQDN | %Forest.FQDN% | Expression | | Update |
forestNetBios | %Forest.Netbios% | Expression | | Update |
objectSid | objectSid | Direct | | Update |
objectSidString | StringFromSid([objectSid]) | Expression | | Update |
pwdLastSet | IIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL) | Expression | | Update |
sourceAnchor | IIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))) | Expression | | Update |
userPrincipalName | IIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present"))) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - User Common |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 106 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADUserCommon.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | adminDescription | NOTSTARTSWITH | User_ |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | IIF(BitAnd([userAccountControl],2)=0,True,False) | Expression | | Update |
accountName | sAMAccountName | Direct | | Update |
assistant | assistant | Direct | | Update |
c | Trim([c]) | Expression | | Update |
cn | cn | Direct | | Update |
co | Trim([co]) | Expression | | Update |
company | Trim([company]) | Expression | | Update |
countryCode | countryCode | Direct | | Update |
department | Trim([department]) | Expression | | Update |
description | IIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448)) | Expression | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
domainFQDN | %Domain.FQDN% | Expression | | Update |
domainNetBios | %Domain.Netbios% | Expression | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
facsimileTelephoneNumber | Trim([facsimileTelephoneNumber]) | Expression | | Update |
forestFQDN | %Forest.FQDN% | Expression | | Update |
forestNetBios | %Forest.Netbios% | Expression | | Update |
givenName | Trim([givenName]) | Expression | | Update |
homePhone | Trim([homePhone]) | Expression | | Update |
info | Left(Trim([info]),448) | Expression | | Update |
initials | Trim([initials]) | Expression | | Update |
ipPhone | Trim([ipPhone]) | Expression | | Update |
l | Trim([l]) | Expression | | Update |
mail | Trim([mail]) | Expression | | Update |
manager | manager | Direct | | Update |
middleName | Trim([middleName]) | Expression | | Update |
mobile | Trim([mobile]) | Expression | | Update |
objectSid | objectSid | Direct | | Update |
objectSidString | StringFromSid([objectSid]) | Expression | | Update |
otherFacsimileTelephoneNumber | Trim([otherFacsimileTelephoneNumber]) | Expression | | Update |
otherHomePhone | Trim([otherHomePhone]) | Expression | | Update |
otherIpPhone | Trim([otherIpPhone]) | Expression | | Update |
otherMobile | Trim([otherMobile]) | Expression | | Update |
otherPager | Trim([otherPager]) | Expression | | Update |
otherTelephone | Trim([otherTelephone]) | Expression | | Update |
pager | Trim([pager]) | Expression | | Update |
photo | photo | Direct | | Update |
physicalDeliveryOfficeName | Trim([physicalDeliveryOfficeName]) | Expression | | Update |
postalCode | Trim([postalCode]) | Expression | | Update |
postOfficeBox | IIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448)) | Expression | | Update |
preferredLanguage | Trim([preferredLanguage]) | Expression | | Update |
proxyAddresses | RemoveDuplicates(Trim(ImportedValue("proxyAddresses"))) | Expression | | Update |
pwdLastSet | IIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL) | Expression | | Update |
sn | Trim([sn]) | Expression | | Update |
sourceAnchor | IIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))) | Expression | | Update |
sourceObjectType | IIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User") | Expression | | Update |
st | Trim([st]) | Expression | | Update |
streetAddress | Trim([streetAddress]) | Expression | | Update |
telephoneNumber | Trim([telephoneNumber]) | Expression | | Update |
thumbnailPhoto | thumbnailPhoto | Direct | | Update |
title | Trim([title]) | Expression | | Update |
url | IIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448)) | Expression | | Update |
userPrincipalName | IIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present"))) | Expression | | Update |
wWWHomePage | Trim([wWWHomePage]) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - User Common from Exchange |
Description | Attributes from the forest where the user has an Exchange mailbox. |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 104 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADUserCommonfromExchange.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | mailNickname | ISNOTNULL | |
1 | adminDescription | NOTSTARTSWITH | User_ |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
accountEnabled | IIF(BitAnd([userAccountControl],2)=0,True,False) | Expression | | Update |
accountName | sAMAccountName | Direct | | Update |
assistant | assistant | Direct | | Update |
c | Trim([c]) | Expression | | Update |
cn | cn | Direct | | Update |
co | Trim([co]) | Expression | | Update |
company | Trim([company]) | Expression | | Update |
countryCode | countryCode | Direct | | Update |
department | Trim([department]) | Expression | | Update |
description | IIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448)) | Expression | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
facsimileTelephoneNumber | Trim([facsimileTelephoneNumber]) | Expression | | Update |
givenName | Trim([givenName]) | Expression | | Update |
homePhone | Trim([homePhone]) | Expression | | Update |
info | Left(Trim([info]),448) | Expression | | Update |
initials | Trim([initials]) | Expression | | Update |
ipPhone | Trim([ipPhone]) | Expression | | Update |
l | Trim([l]) | Expression | | Update |
mail | Trim([mail]) | Expression | | Update |
manager | manager | Direct | | Update |
middleName | Trim([middleName]) | Expression | | Update |
mobile | Trim([mobile]) | Expression | | Update |
otherFacsimileTelephoneNumber | Trim([otherFacsimileTelephoneNumber]) | Expression | | Update |
otherHomePhone | Trim([otherHomePhone]) | Expression | | Update |
otherIpPhone | Trim([otherIpPhone]) | Expression | | Update |
otherMobile | Trim([otherMobile]) | Expression | | Update |
otherPager | Trim([otherPager]) | Expression | | Update |
otherTelephone | Trim([otherTelephone]) | Expression | | Update |
pager | Trim([pager]) | Expression | | Update |
photo | photo | Direct | | Update |
physicalDeliveryOfficeName | Trim([physicalDeliveryOfficeName]) | Expression | | Update |
postalCode | Trim([postalCode]) | Expression | | Update |
postOfficeBox | IIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448)) | Expression | | Update |
preferredLanguage | Trim([preferredLanguage]) | Expression | | Update |
proxyAddresses | RemoveDuplicates(Trim(ImportedValue("proxyAddresses"))) | Expression | | Update |
sn | Trim([sn]) | Expression | | Update |
sourceObjectType | IIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User") | Expression | | Update |
st | Trim([st]) | Expression | | Update |
streetAddress | Trim([streetAddress]) | Expression | | Update |
telephoneNumber | Trim([telephoneNumber]) | Expression | | Update |
thumbnailPhoto | thumbnailPhoto | Direct | | Update |
title | Trim([title]) | Expression | | Update |
url | IIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448)) | Expression | | Update |
wWWHomePage | Trim([wWWHomePage]) | Expression | | Update |
Description |
Setting | Configuration |
Name | In from AD - User Exchange |
Description | User object with Exchange schema in Active Directory. |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 108 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADUserExchange.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | mailNickname | ISNOTNULL | |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
authOrig | authOrig | Direct | | Update |
contributingConnectorExchange | %Connector.ID% | Expression | | Update |
dLMemRejectPerms | dLMemRejectPerms | Direct | | Update |
dLMemSubmitPerms | dLMemSubmitPerms | Direct | | Update |
extensionAttribute1 | Trim([extensionAttribute1]) | Expression | | Update |
extensionAttribute10 | Trim([extensionAttribute10]) | Expression | | Update |
extensionAttribute11 | Trim([extensionAttribute11]) | Expression | | Update |
extensionAttribute12 | Trim([extensionAttribute12]) | Expression | | Update |
extensionAttribute13 | Trim([extensionAttribute13]) | Expression | | Update |
extensionAttribute14 | Trim([extensionAttribute14]) | Expression | | Update |
extensionAttribute15 | Trim([extensionAttribute15]) | Expression | | Update |
extensionAttribute2 | Trim([extensionAttribute2]) | Expression | | Update |
extensionAttribute3 | Trim([extensionAttribute3]) | Expression | | Update |
extensionAttribute4 | Trim([extensionAttribute4]) | Expression | | Update |
extensionAttribute5 | Trim([extensionAttribute5]) | Expression | | Update |
extensionAttribute6 | Trim([extensionAttribute6]) | Expression | | Update |
extensionAttribute7 | Trim([extensionAttribute7]) | Expression | | Update |
extensionAttribute8 | Trim([extensionAttribute8]) | Expression | | Update |
extensionAttribute9 | Trim([extensionAttribute9]) | Expression | | Update |
legacyExchangeDN | legacyExchangeDN | Direct | | Update |
mailNickname | mailNickname | Direct | | Update |
msDS-HABSeniorityIndex | msDS-HABSeniorityIndex | Direct | | Update |
msDS-PhoneticDisplayName | msDS-PhoneticDisplayName | Direct | | Update |
msExchArchiveGUID | msExchArchiveGUID | Direct | | Update |
msExchArchiveName | msExchArchiveName | Direct | | Update |
msExchAssistantName | msExchAssistantName | Direct | | Update |
msExchBlockedSendersHash | msExchBlockedSendersHash | Direct | | Update |
msExchBypassModerationFromDLMembersLink | msExchBypassModerationFromDLMembersBL | Direct | | Update |
msExchBypassModerationLink | msExchBypassModerationLink | Direct | | Update |
msExchDelegateListLink | msExchDelegateListLink | Direct | | Update |
msExchELCExpirySuspensionEnd | msExchELCExpirySuspensionEnd | Direct | | Update |
msExchELCExpirySuspensionStart | msExchELCExpirySuspensionStart | Direct | | Update |
msExchELCMailboxFlags | msExchELCMailboxFlags | Direct | | Update |
msExchEnableModeration | msExchEnableModeration | Direct | | Update |
msExchHideFromAddressLists | msExchHideFromAddressLists | Direct | | Update |
msExchImmutableId | msExchImmutableId | Direct | | Update |
msExchMailboxGuid | msExchMailboxGuid | Direct | | Update |
msExchMasterAccountSid | msExchMasterAccountSid | Direct | | Update |
msExchModeratedByLink | msExchModeratedByLink | Direct | | Update |
msExchModerationFlags | msExchModerationFlags | Direct | | Update |
msExchRecipientDisplayType | msExchRecipientDisplayType | Direct | | Update |
msExchRecipientTypeDetails | msExchRecipientTypeDetails | Direct | | Update |
msExchRequireAuthToSendTo | msExchRequireAuthToSendTo | Direct | | Update |
msExchResourceCapacity | msExchResourceCapacity | Direct | | Update |
msExchResourceDisplay | msExchResourceDisplay | Direct | | Update |
msExchResourceMetaData | msExchResourceMetaData | Direct | | Update |
msExchResourceSearchProperties | msExchResourceSearchProperties | Direct | | Update |
msExchRetentionComment | msExchRetentionComment | Direct | | Update |
msExchRetentionURL | msExchRetentionURL | Direct | | Update |
msExchSafeRecipientsHash | msExchSafeRecipientsHash | Direct | | Update |
msExchSafeSendersHash | msExchSafeSendersHash | Direct | | Update |
msExchSenderHintTranslations | msExchSenderHintTranslations | Direct | | Update |
publicDelegates | publicDelegates | Direct | | Update |
targetAddress | targetAddress | Direct | | Update |
telephoneAssistant | Trim([telephoneAssistant]) | Expression | | Update |
unauthOrig | unauthOrig | Direct | | Update |
userCertificate | userCertificate | Direct | | Update |
userSMIMECertificate | userSMIMECertificate | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - User Join |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Provision |
Precedence | 100 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADUserJoin.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | isCriticalSystemObject | NOTEQUAL | TRUE |
1 | adminDescription | NOTSTARTSWITH | User_ |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | sourceAnchorBinary | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
cloudFiltered | IIF(IsPresent([isCriticalSystemObject]) || IsPresent([sAMAccountName]) = False || [sAMAccountName] = "SUPPORT_388945a0" || Left([mailNickname], 14) = "SystemMailbox{" || Left([sAMAccountName], 4) = "AAD_" || (Left([mailNickname], 4) = "CAS_" && (InStr([mailNickname], "}") > 0)) || (Left([sAMAccountName], 4) = "CAS_" && (InStr([sAMAccountName], "}") > 0)) || Left([sAMAccountName], 5) = "MSOL_" || CBool(IIF(IsPresent([msExchRecipientTypeDetails]),BitAnd([msExchRecipientTypeDetails],&H21C07000) > 0,NULL)) || CBool(InStr(DNComponent(CRef([dn]),1),"\\0ACNF:")>0), True, NULL) | Expression | | Update |
sourceAnchorBinary | objectGUID | Direct | | Update |
Description |
Setting | Configuration |
Name | In from AD - Computer Join |
Description | |
Direction | Inbound |
Connected System | contoso.com |
Connected System Object Type | computer |
Metaverse Object Type | device |
Link Type | Provision |
Precedence | 156 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.InfromADComputerJoin.001 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
1 | objectGUID | deviceId | |
Transformations |
Target (MV) Attribute | Source | Flow Type | Apply Once | Merge Type |
- | - | - | - | - |
accountEnabled | IIF(BitAnd([userAccountControl],2)=0,True,False) | Expression | | Update |
cloudCreated | CBool(0) | Expression | true | Update |
cloudFiltered | IIF(IsNullOrEmpty([userCertificate]),True,NULL) | Expression | | Update |
deviceId | objectGUID | Direct | | Update |
deviceOSType | operatingSystem | Direct | | Update |
deviceOSVersion | operatingSystemVersion | Direct | | Update |
deviceTrustType | ServerAd | Constant | | Update |
displayName | IIF(IsNullOrEmpty([displayName]),[cn],[displayName]) | Expression | | Update |
objectSid | objectSid | Direct | | Update |
registeredOwnerReference | mS-DS-CreatorSID | Direct | true | Update |
sourceAnchor | ConvertToBase64([objectGUID]) | Expression | | Update |
sourceObjectType | Computer | Constant | | Update |
userCertificate | userCertificate | Direct | | Update |
Description |
Setting | Configuration |
Name | Out to AD - Contact Exchange Hybrid |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | contact |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 152 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADContactExchangeHybrid.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
proxyAddresses | IIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN]) | Expression | | MergeCaseInsensitive |
Description |
Setting | Configuration |
Name | Out to AD - Contact Join |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | contact |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 148 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADContactJoin.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | mail | mail | |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
- | - | - | - | - |
Description |
Setting | Configuration |
Name | Out to AD - Group Exchange Hybrid |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | group |
Metaverse Object Type | group |
Link Type | Join |
Precedence | 153 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADGroupExchangeHybrid.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | cloudMastered | NOTEQUAL | True |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
proxyAddresses | IIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN]) | Expression | | MergeCaseInsensitive |
Description |
Setting | Configuration |
Name | Out to AD - Group Join |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | group |
Metaverse Object Type | group |
Link Type | Join |
Precedence | 149 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADGroupJoin.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | cloudMastered | NOTEQUAL | True |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | sourceAnchorBinary | |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
- | - | - | - | - |
Description |
Setting | Configuration |
Name | Out to AD - InetOrgPerson Exchange Hybrid |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 154 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADInetOrgPersonExchangeHybrid.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | contributingConnectorExchange | EQUAL | %Connector.ID% |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
msExchBlockedSendersHash | IIF([cloudSOAExchMailbox] = True,[cloudMSExchBlockedSendersHash],IgnoreThisFlow) | Expression | | Update |
msExchSafeRecipientsHash | IIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeRecipientsHash],IgnoreThisFlow) | Expression | | Update |
msExchSafeSendersHash | IIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeSendersHash],IgnoreThisFlow) | Expression | | Update |
proxyAddresses | IIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN]) | Expression | | MergeCaseInsensitive |
Description |
Setting | Configuration |
Name | Out to AD - InetOrgPerson Join |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | inetOrgPerson |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 150 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADInetOrgPersonJoin.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | sourceAnchorBinary | |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
- | - | - | - | - |
Description |
Setting | Configuration |
Name | Out to AD - User Exchange Hybrid |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 155 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADUserExchangeHybrid.003 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
- | - | - | - |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
- | - | - | - |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
msExchBlockedSendersHash | IIF([cloudSOAExchMailbox] = True,[cloudMSExchBlockedSendersHash],IgnoreThisFlow) | Expression | | Update |
msExchSafeRecipientsHash | IIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeRecipientsHash],IgnoreThisFlow) | Expression | | Update |
msExchSafeSendersHash | IIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeSendersHash],IgnoreThisFlow) | Expression | | Update |
proxyAddresses | IIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN]) | Expression | | MergeCaseInsensitive |
Description |
Setting | Configuration |
Name | Out to AD - User Join |
Description | |
Direction | Outbound |
Connected System | contoso.com |
Connected System Object Type | user |
Metaverse Object Type | person |
Link Type | Join |
Precedence | 151 |
Soft Delete Expiry Interval | 00:00:00 |
Tag | Microsoft.OuttoADUserJoinSOAInAD.004 |
Enable Password Sync | No |
Scoping Filter |
Group# | Attribute | Operator | Value |
1 | cloudMastered | EQUAL | False |
Join Rules |
Group# | Source Attribute | Target Attribute | Case Sensitive |
1 | objectGUID | sourceAnchorBinary | |
Transformations |
Target (CS) Attribute | Source | Flow Type | Apply Once | Merge Type |
- | - | - | - | - |