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

AAD Connect Sync Service Configuration

Global Settings

SettingValue
Microsoft.AADFilter.ApplicationList
Microsoft.AADFilter.AttributeExclusionList
Microsoft.DeviceWriteBack.Container
Microsoft.DeviceWriteBack.Forest
Microsoft.DirectoryExtension.SourceTargetAttributesMap
Microsoft.GroupWriteBack.Container
Microsoft.GroupWriteBack.Forest
Microsoft.OptionalFeature.DeviceWriteBackFalse
Microsoft.OptionalFeature.DeviceWriteUpTrue
Microsoft.OptionalFeature.DirectoryExtensionFalse
Microsoft.OptionalFeature.DirectoryExtensionAttributes
Microsoft.OptionalFeature.ExportDeletionThresholdTrue
Microsoft.OptionalFeature.ExportDeletionThresholdValue500
Microsoft.OptionalFeature.FilterAADFalse
Microsoft.OptionalFeature.GroupFilteringFalse
Microsoft.OptionalFeature.GroupWriteBackFalse
Microsoft.OptionalFeature.HybridExchangeTrue
Microsoft.OptionalFeature.PasswordHashSyncTrue
Microsoft.OptionalFeature.PasswordWritebackFalse
Microsoft.OptionalFeature.UserWriteBackFalse
Microsoft.SynchronizationOption.AnchorAttributeobjectGUID
Microsoft.SynchronizationOption.CustomAttribute
Microsoft.SynchronizationOption.JoinCriteriaAlwaysProvision
Microsoft.SynchronizationOption.UPNAttributeuserPrincipalName
Microsoft.Synchronize.StagingModeFalse
Microsoft.Synchronize.SynchronizationPolicyDelta
Microsoft.Synchronize.SynchronizationScheduleFalse
Microsoft.UserWriteBack.Container
Microsoft.UserWriteBack.Forest
Microsoft.Version.SynchronizationRuleImmutableTagV1

contoso.com Connector Configuration

Synchronization Rules

Inbound

0-In from AD - Computer Join
Description
SettingConfiguration
Name0-In from AD - Computer Join
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typecomputer
Metaverse Object Typedevice
Link TypeProvision
Precedence156
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADComputerJoin.001
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDdeviceId
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledIIF(BitAnd([userAccountControl],2)=0,True,False)ExpressionUpdate
cloudCreatedCBool(0)ExpressiontrueUpdate
cloudFilteredIIF(IsNullOrEmpty([userCertificate]),True,NULL)ExpressionUpdate
deviceIdobjectGUIDDirectUpdate
deviceOSTypeoperatingSystemDirectUpdate
deviceOSVersionoperatingSystemVersionDirectUpdate
deviceTrustTypeServerAdConstantUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
objectSidobjectSidDirectUpdate
registeredOwnerReferencemS-DS-CreatorSIDDirecttrueUpdate
sourceAnchorConvertToBase64([objectGUID])ExpressionUpdate
sourceObjectTypeComputerConstantUpdate
userCertificateuserCertificateDirectUpdate
In from AD - Contact Common
Description
SettingConfiguration
NameIn from AD - Contact Common
DescriptionContact object with Exchange schema in Active Directory.
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typecontact
Metaverse Object Typeperson
Link TypeJoin
Precedence114
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADContactCommon.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
assistantassistantDirectUpdate
authOrigauthOrigDirectUpdate
cTrim([c])ExpressionUpdate
cncnDirectUpdate
coTrim([co])ExpressionUpdate
companyTrim([company])ExpressionUpdate
countryCodecountryCodeDirectUpdate
departmentTrim([department])ExpressionUpdate
descriptionIIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448))ExpressionUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
dLMemRejectPermsdLMemRejectPermsDirectUpdate
dLMemSubmitPermsdLMemSubmitPermsDirectUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
facsimileTelephoneNumberTrim([facsimileTelephoneNumber])ExpressionUpdate
givenNameTrim([givenName])ExpressionUpdate
homePhoneTrim([homePhone])ExpressionUpdate
infoLeft(Trim([info]),448)ExpressionUpdate
initialsTrim([initials])ExpressionUpdate
ipPhoneTrim([ipPhone])ExpressionUpdate
lTrim([l])ExpressionUpdate
legacyExchangeDNIIF(IsPresent([legacyExchangeDN]), [legacyExchangeDN], NULL)ExpressionUpdate
mailTrim([mail])ExpressionUpdate
mailNicknameIIF(IsPresent([mailNickname]), [mailNickname], [cn])ExpressionUpdate
managermanagerDirectUpdate
middleNameTrim([middleName])ExpressionUpdate
mobileTrim([mobile])ExpressionUpdate
msDS-HABSeniorityIndexmsDS-HABSeniorityIndexDirectUpdate
msDS-PhoneticDisplayNamemsDS-PhoneticDisplayNameDirectUpdate
msExchAssistantNamemsExchAssistantNameDirectUpdate
msExchBlockedSendersHashmsExchBlockedSendersHashDirectUpdate
msExchBypassModerationFromDLMembersLinkmsExchBypassModerationFromDLMembersLinkDirectUpdate
msExchBypassModerationLinkmsExchBypassModerationLinkDirectUpdate
msExchHideFromAddressListsmsExchHideFromAddressListsDirectUpdate
msExchModeratedByLinkmsExchModeratedByLinkDirectUpdate
msExchModerationFlagsmsExchModerationFlagsDirectUpdate
msExchRecipientDisplayTypemsExchRecipientDisplayTypeDirectUpdate
msExchRecipientTypeDetailsmsExchRecipientTypeDetailsDirectUpdate
msExchRequireAuthToSendTomsExchRequireAuthToSendToDirectUpdate
msExchRetentionCommentmsExchRetentionCommentDirectUpdate
msExchRetentionURLmsExchRetentionURLDirectUpdate
msExchSafeRecipientsHashmsExchSafeRecipientsHashDirectUpdate
msExchSafeSendersHashmsExchSafeSendersHashDirectUpdate
msExchSenderHintTranslationsmsExchSenderHintTranslationsDirectUpdate
otherFacsimileTelephoneNumberTrim([otherFacsimileTelephoneNumber])ExpressionUpdate
otherHomePhoneTrim([otherHomePhone])ExpressionUpdate
otherIpPhoneTrim([otherIpPhone])ExpressionUpdate
otherMobileTrim([otherMobile])ExpressionUpdate
otherPagerTrim([otherPager])ExpressionUpdate
otherTelephoneTrim([otherTelephone])ExpressionUpdate
pagerTrim([pager])ExpressionUpdate
physicalDeliveryOfficeNameTrim([physicalDeliveryOfficeName])ExpressionUpdate
postalCodeTrim([postalCode])ExpressionUpdate
postOfficeBoxIIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448))ExpressionUpdate
proxyAddressesRemoveDuplicates(Trim(ImportedValue("proxyAddresses")))ExpressionUpdate
publicDelegatespublicDelegatesDirectUpdate
snTrim([sn])ExpressionUpdate
sourceAnchorConvertToBase64([objectGUID])ExpressionUpdate
sourceAnchorBinaryobjectGUIDDirectUpdate
sourceObjectTypeContactConstantUpdate
stTrim([st])ExpressionUpdate
streetAddressTrim([streetAddress])ExpressionUpdate
targetAddresstargetAddressDirectUpdate
telephoneAssistantTrim([telephoneAssistant])ExpressionUpdate
telephoneNumberTrim([telephoneNumber])ExpressionUpdate
thumbnailPhotothumbnailPhotoDirectUpdate
titleTrim([title])ExpressionUpdate
unauthOrigunauthOrigDirectUpdate
urlIIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448))ExpressionUpdate
userCertificateuserCertificateDirectUpdate
userSMIMECertificateuserSMIMECertificateDirectUpdate
wWWHomePageTrim([wWWHomePage])ExpressionUpdate
In from AD - Contact Join
Description
SettingConfiguration
NameIn from AD - Contact Join
DescriptionContact object with default Active Directory schema.
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typecontact
Metaverse Object Typeperson
Link TypeProvision
Precedence113
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADContactJoin.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1mailmail
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
cloudFilteredIIF(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)ExpressionUpdate
mailEnabledIIF(( (IsPresent([proxyAddresses]) = True) && (Contains([proxyAddresses], "SMTP:") > 0) && (InStr(Item([proxyAddresses], Contains([proxyAddresses], "SMTP:")), "@") > 0)) || (IsPresent([mail]) = True && (InStr([mail], "@") > 0)), True, False)ExpressionUpdate
In from AD - ForeignSecurityPrincipal Join User
Description
SettingConfiguration
NameIn from AD - ForeignSecurityPrincipal Join User
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object TypeforeignSecurityPrincipal
Metaverse Object Type*
Link TypeJoin
Precedence115
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADForeignSecurityPrincipalJoinUser.001
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1cnobjectSidString
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
-----
In from AD - Group Common
Description
SettingConfiguration
NameIn from AD - Group Common
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typegroup
Metaverse Object Typegroup
Link TypeJoin
Precedence112
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADGroupCommon.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1isCriticalSystemObjectNOTEQUALTrue
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
cncnDirectUpdate
descriptionIIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448))ExpressionUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
infoLeft(Trim([info]),448)ExpressionUpdate
mailTrim([mail])ExpressionUpdate
managedBymanagedByDirectUpdate
membermemberDirectUpdate
memberCountValueCount("member")ExpressionUpdate
objectSidobjectSidDirectUpdate
objectSidStringStringFromSid([objectSid])ExpressionUpdate
proxyAddressesRemoveDuplicates(Trim(ImportedValue("proxyAddresses")))ExpressionUpdate
securityEnabledCBool(BitAnd([groupType],-2147483648))ExpressionUpdate
sourceAnchorConvertToBase64([objectGUID])ExpressionUpdate
sourceAnchorBinaryobjectGUIDDirectUpdate
In from AD - Group Exchange
Description
SettingConfiguration
NameIn from AD - Group Exchange
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typegroup
Metaverse Object Typegroup
Link TypeJoin
Precedence111
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADGroupExchange.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
authOrigauthOrigDirectUpdate
dLMemRejectPermsdLMemRejectPermsDirectUpdate
dLMemSubmitPermsdLMemSubmitPermsDirectUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
hideDLMembershiphideDLMembershipDirectUpdate
legacyExchangeDNlegacyExchangeDNDirectUpdate
mailNicknamemailNicknameDirectUpdate
msDS-PhoneticDisplayNamemsDS-PhoneticDisplayNameDirectUpdate
msExchBypassModerationFromDLMembersLinkmsExchBypassModerationFromDLMembersLinkDirectUpdate
msExchBypassModerationLinkmsExchBypassModerationLinkDirectUpdate
msExchCoManagedByLinkmsExchCoManagedByLinkDirectUpdate
msExchEnableModerationmsExchEnableModerationDirectUpdate
msExchGroupDepartRestrictionmsExchGroupDepartRestrictionDirectUpdate
msExchGroupJoinRestrictionmsExchGroupJoinRestrictionDirectUpdate
msExchHideFromAddressListsmsExchHideFromAddressListsDirectUpdate
msExchModeratedByLinkmsExchModeratedByLinkDirectUpdate
msExchModerationFlagsmsExchModerationFlagsDirectUpdate
msExchRecipientDisplayTypemsExchRecipientDisplayTypeDirectUpdate
msExchRecipientTypeDetailsmsExchRecipientTypeDetailsDirectUpdate
msExchRequireAuthToSendTomsExchRequireAuthToSendToDirectUpdate
msExchRetentionCommentmsExchRetentionCommentDirectUpdate
msExchRetentionURLmsExchRetentionURLDirectUpdate
msExchSenderHintTranslationsmsExchSenderHintTranslationsDirectUpdate
oOFReplyToOriginatoroOFReplyToOriginatorDirectUpdate
publicDelegatespublicDelegatesDirectUpdate
reportToOriginatorreportToOriginatorDirectUpdate
reportToOwnerreportToOwnerDirectUpdate
unauthOrigunauthOrigDirectUpdate
In from AD - Group Join
Description
SettingConfiguration
NameIn from AD - Group Join
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typegroup
Metaverse Object Typegroup
Link TypeProvision
Precedence110
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADGroupJoin.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1isCriticalSystemObjectNOTEQUALTrue
1adminDescriptionNOTSTARTSWITHGroup_
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDsourceAnchorBinary
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
cloudFilteredIIF(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)ExpressionUpdate
mailEnabledIIF(( (IsPresent([proxyAddresses]) = True) && (Contains([proxyAddresses], "SMTP:") > 0) && (InStr(Item([proxyAddresses], Contains([proxyAddresses], "SMTP:")), "@") > 0)) || (IsPresent([mail]) = True && (InStr([mail], "@") > 0)), True, False)ExpressionUpdate
In from AD - InetOrgPerson AccountEnabled
Description
SettingConfiguration
NameIn from AD - InetOrgPerson AccountEnabled
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeJoin
Precedence103
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADInetOrgPersonAccountEnabled.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1userAccountControlISBITNOTSET2
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledTrueConstantUpdate
cncnDirectUpdate
contributingConnectorUser%Connector.ID%ExpressionUpdate
domainFQDN%Domain.FQDN%ExpressionUpdate
domainNetBios%Domain.Netbios%ExpressionUpdate
forestFQDN%Forest.FQDN%ExpressionUpdate
forestNetBios%Forest.Netbios%ExpressionUpdate
objectSidobjectSidDirectUpdate
objectSidStringStringFromSid([objectSid])ExpressionUpdate
pwdLastSetIIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL)ExpressionUpdate
sourceAnchorIIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID])))ExpressionUpdate
userPrincipalNameIIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present")))ExpressionUpdate
In from AD - InetOrgPerson Common
Description
SettingConfiguration
NameIn from AD - InetOrgPerson Common
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeJoin
Precedence107
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADInetOrgPersonCommon.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledIIF(BitAnd([userAccountControl],2)=0,True,False)ExpressionUpdate
accountNamesAMAccountNameDirectUpdate
assistantassistantDirectUpdate
cTrim([c])ExpressionUpdate
cncnDirectUpdate
coTrim([co])ExpressionUpdate
companyTrim([company])ExpressionUpdate
countryCodecountryCodeDirectUpdate
departmentTrim([department])ExpressionUpdate
descriptionIIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448))ExpressionUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
domainFQDN%Domain.FQDN%ExpressionUpdate
domainNetBios%Domain.Netbios%ExpressionUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
facsimileTelephoneNumberTrim([facsimileTelephoneNumber])ExpressionUpdate
forestFQDN%Forest.FQDN%ExpressionUpdate
forestNetBios%Forest.Netbios%ExpressionUpdate
givenNameTrim([givenName])ExpressionUpdate
homePhoneTrim([homePhone])ExpressionUpdate
infoLeft(Trim([info]),448)ExpressionUpdate
initialsTrim([initials])ExpressionUpdate
ipPhoneTrim([ipPhone])ExpressionUpdate
lTrim([l])ExpressionUpdate
mailTrim([mail])ExpressionUpdate
managermanagerDirectUpdate
middleNameTrim([middleName])ExpressionUpdate
mobileTrim([mobile])ExpressionUpdate
objectSidobjectSidDirectUpdate
objectSidStringStringFromSid([objectSid])ExpressionUpdate
otherFacsimileTelephoneNumberTrim([otherFacsimileTelephoneNumber])ExpressionUpdate
otherHomePhoneTrim([otherHomePhone])ExpressionUpdate
otherIpPhoneTrim([otherIpPhone])ExpressionUpdate
otherMobileTrim([otherMobile])ExpressionUpdate
otherPagerTrim([otherPager])ExpressionUpdate
otherTelephoneTrim([otherTelephone])ExpressionUpdate
pagerTrim([pager])ExpressionUpdate
photophotoDirectUpdate
physicalDeliveryOfficeNameTrim([physicalDeliveryOfficeName])ExpressionUpdate
postalCodeTrim([postalCode])ExpressionUpdate
postOfficeBoxIIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448))ExpressionUpdate
preferredLanguageTrim([preferredLanguage])ExpressionUpdate
pwdLastSetIIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL)ExpressionUpdate
snTrim([sn])ExpressionUpdate
sourceAnchorIIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID])))ExpressionUpdate
sourceObjectTypeIIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User")ExpressionUpdate
stTrim([st])ExpressionUpdate
streetAddressTrim([streetAddress])ExpressionUpdate
telephoneNumberTrim([telephoneNumber])ExpressionUpdate
thumbnailPhotothumbnailPhotoDirectUpdate
titleTrim([title])ExpressionUpdate
urlIIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448))ExpressionUpdate
userPrincipalNameIIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present")))ExpressionUpdate
wWWHomePageTrim([wWWHomePage])ExpressionUpdate
In from AD - InetOrgPerson Common from Exchange
Description
SettingConfiguration
NameIn from AD - InetOrgPerson Common from Exchange
DescriptionAttributes from the forest where the InetOrgPerson has an Exchange mailbox.
DirectionInbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeJoin
Precedence105
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADInetOrgPersonCommonfromExchange.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1mailNicknameISNOTNULL
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledIIF(BitAnd([userAccountControl],2)=0,True,False)ExpressionUpdate
accountNamesAMAccountNameDirectUpdate
assistantassistantDirectUpdate
cTrim([c])ExpressionUpdate
cncnDirectUpdate
coTrim([co])ExpressionUpdate
companyTrim([company])ExpressionUpdate
countryCodecountryCodeDirectUpdate
departmentTrim([department])ExpressionUpdate
descriptionIIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448))ExpressionUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
facsimileTelephoneNumberTrim([facsimileTelephoneNumber])ExpressionUpdate
givenNameTrim([givenName])ExpressionUpdate
homePhoneTrim([homePhone])ExpressionUpdate
infoLeft(Trim([info]),448)ExpressionUpdate
initialsTrim([initials])ExpressionUpdate
ipPhoneTrim([ipPhone])ExpressionUpdate
lTrim([l])ExpressionUpdate
mailTrim([mail])ExpressionUpdate
managermanagerDirectUpdate
middleNameTrim([middleName])ExpressionUpdate
mobileTrim([mobile])ExpressionUpdate
otherFacsimileTelephoneNumberTrim([otherFacsimileTelephoneNumber])ExpressionUpdate
otherHomePhoneTrim([otherHomePhone])ExpressionUpdate
otherIpPhoneTrim([otherIpPhone])ExpressionUpdate
otherMobileTrim([otherMobile])ExpressionUpdate
otherPagerTrim([otherPager])ExpressionUpdate
otherTelephoneTrim([otherTelephone])ExpressionUpdate
pagerTrim([pager])ExpressionUpdate
photophotoDirectUpdate
physicalDeliveryOfficeNameTrim([physicalDeliveryOfficeName])ExpressionUpdate
postalCodeTrim([postalCode])ExpressionUpdate
postOfficeBoxIIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448))ExpressionUpdate
preferredLanguageTrim([preferredLanguage])ExpressionUpdate
proxyAddressesRemoveDuplicates(Trim(ImportedValue("proxyAddresses")))ExpressionUpdate
snTrim([sn])ExpressionUpdate
sourceObjectTypeIIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User")ExpressionUpdate
stTrim([st])ExpressionUpdate
streetAddressTrim([streetAddress])ExpressionUpdate
telephoneNumberTrim([telephoneNumber])ExpressionUpdate
thumbnailPhotothumbnailPhotoDirectUpdate
titleTrim([title])ExpressionUpdate
urlIIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448))ExpressionUpdate
wWWHomePageTrim([wWWHomePage])ExpressionUpdate
In from AD - InetOrgPerson Exchange
Description
SettingConfiguration
NameIn from AD - InetOrgPerson Exchange
DescriptionInetOrgPerson object with Exchange schema in Active Directory.
DirectionInbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeJoin
Precedence109
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADInetOrgPersonExchange.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1mailNicknameISNOTNULL
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
authOrigauthOrigDirectUpdate
contributingConnectorExchange%Connector.ID%ExpressionUpdate
dLMemRejectPermsdLMemRejectPermsDirectUpdate
dLMemSubmitPermsdLMemSubmitPermsDirectUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
legacyExchangeDNlegacyExchangeDNDirectUpdate
mailNicknamemailNicknameDirectUpdate
msDS-HABSeniorityIndexmsDS-HABSeniorityIndexDirectUpdate
msDS-PhoneticDisplayNamemsDS-PhoneticDisplayNameDirectUpdate
msExchArchiveGUIDmsExchArchiveGUIDDirectUpdate
msExchArchiveNamemsExchArchiveNameDirectUpdate
msExchAssistantNamemsExchAssistantNameDirectUpdate
msExchBlockedSendersHashmsExchBlockedSendersHashDirectUpdate
msExchBypassModerationFromDLMembersLinkmsExchBypassModerationFromDLMembersBLDirectUpdate
msExchBypassModerationLinkmsExchBypassModerationLinkDirectUpdate
msExchDelegateListLinkmsExchDelegateListLinkDirectUpdate
msExchELCExpirySuspensionEndmsExchELCExpirySuspensionEndDirectUpdate
msExchELCExpirySuspensionStartmsExchELCExpirySuspensionStartDirectUpdate
msExchELCMailboxFlagsmsExchELCMailboxFlagsDirectUpdate
msExchEnableModerationmsExchEnableModerationDirectUpdate
msExchHideFromAddressListsmsExchHideFromAddressListsDirectUpdate
msExchImmutableIdmsExchImmutableIdDirectUpdate
msExchMailboxGuidmsExchMailboxGuidDirectUpdate
msExchMasterAccountSidmsExchMasterAccountSidDirectUpdate
msExchModeratedByLinkmsExchModeratedByLinkDirectUpdate
msExchModerationFlagsmsExchModerationFlagsDirectUpdate
msExchRecipientDisplayTypemsExchRecipientDisplayTypeDirectUpdate
msExchRecipientTypeDetailsmsExchRecipientTypeDetailsDirectUpdate
msExchRequireAuthToSendTomsExchRequireAuthToSendToDirectUpdate
msExchResourceCapacitymsExchResourceCapacityDirectUpdate
msExchResourceDisplaymsExchResourceDisplayDirectUpdate
msExchResourceMetaDatamsExchResourceMetaDataDirectUpdate
msExchResourceSearchPropertiesmsExchResourceSearchPropertiesDirectUpdate
msExchRetentionCommentmsExchRetentionCommentDirectUpdate
msExchRetentionURLmsExchRetentionURLDirectUpdate
msExchSafeRecipientsHashmsExchSafeRecipientsHashDirectUpdate
msExchSafeSendersHashmsExchSafeSendersHashDirectUpdate
msExchSenderHintTranslationsmsExchSenderHintTranslationsDirectUpdate
publicDelegatespublicDelegatesDirectUpdate
targetAddresstargetAddressDirectUpdate
telephoneAssistantTrim([telephoneAssistant])ExpressionUpdate
unauthOrigunauthOrigDirectUpdate
userCertificateuserCertificateDirectUpdate
userSMIMECertificateuserSMIMECertificateDirectUpdate
In from AD - InetOrgPerson Join
Description
SettingConfiguration
NameIn from AD - InetOrgPerson Join
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeProvision
Precedence101
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADInetOrgPersonJoin.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1isCriticalSystemObjectNOTEQUALTRUE
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDsourceAnchorBinary
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
cloudFilteredIIF(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)ExpressionUpdate
sourceAnchorBinaryobjectGUIDDirectUpdate
In from AD - User AccountEnabled
Description
SettingConfiguration
NameIn from AD - User AccountEnabled
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeJoin
Precedence102
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADUserAccountEnabled.004
Enable Password SyncYes
Scoping Filter
Group#AttributeOperatorValue
1userAccountControlISBITNOTSET2
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledTrueConstantUpdate
cncnDirectUpdate
contributingConnectorUser%Connector.ID%ExpressionUpdate
domainFQDN%Domain.FQDN%ExpressionUpdate
domainNetBios%Domain.Netbios%ExpressionUpdate
forestFQDN%Forest.FQDN%ExpressionUpdate
forestNetBios%Forest.Netbios%ExpressionUpdate
objectSidobjectSidDirectUpdate
objectSidStringStringFromSid([objectSid])ExpressionUpdate
pwdLastSetIIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL)ExpressionUpdate
sourceAnchorIIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID])))ExpressionUpdate
userPrincipalNameIIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present")))ExpressionUpdate
In from AD - User Common
Description
SettingConfiguration
NameIn from AD - User Common
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeJoin
Precedence106
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADUserCommon.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1adminDescriptionNOTSTARTSWITHUser_
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledIIF(BitAnd([userAccountControl],2)=0,True,False)ExpressionUpdate
accountNamesAMAccountNameDirectUpdate
assistantassistantDirectUpdate
cTrim([c])ExpressionUpdate
cncnDirectUpdate
coTrim([co])ExpressionUpdate
companyTrim([company])ExpressionUpdate
countryCodecountryCodeDirectUpdate
departmentTrim([department])ExpressionUpdate
descriptionIIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448))ExpressionUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
domainFQDN%Domain.FQDN%ExpressionUpdate
domainNetBios%Domain.Netbios%ExpressionUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
facsimileTelephoneNumberTrim([facsimileTelephoneNumber])ExpressionUpdate
forestFQDN%Forest.FQDN%ExpressionUpdate
forestNetBios%Forest.Netbios%ExpressionUpdate
givenNameTrim([givenName])ExpressionUpdate
homePhoneTrim([homePhone])ExpressionUpdate
infoLeft(Trim([info]),448)ExpressionUpdate
initialsTrim([initials])ExpressionUpdate
ipPhoneTrim([ipPhone])ExpressionUpdate
lTrim([l])ExpressionUpdate
mailTrim([mail])ExpressionUpdate
managermanagerDirectUpdate
middleNameTrim([middleName])ExpressionUpdate
mobileTrim([mobile])ExpressionUpdate
objectSidobjectSidDirectUpdate
objectSidStringStringFromSid([objectSid])ExpressionUpdate
otherFacsimileTelephoneNumberTrim([otherFacsimileTelephoneNumber])ExpressionUpdate
otherHomePhoneTrim([otherHomePhone])ExpressionUpdate
otherIpPhoneTrim([otherIpPhone])ExpressionUpdate
otherMobileTrim([otherMobile])ExpressionUpdate
otherPagerTrim([otherPager])ExpressionUpdate
otherTelephoneTrim([otherTelephone])ExpressionUpdate
pagerTrim([pager])ExpressionUpdate
photophotoDirectUpdate
physicalDeliveryOfficeNameTrim([physicalDeliveryOfficeName])ExpressionUpdate
postalCodeTrim([postalCode])ExpressionUpdate
postOfficeBoxIIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448))ExpressionUpdate
preferredLanguageTrim([preferredLanguage])ExpressionUpdate
proxyAddressesRemoveDuplicates(Trim(ImportedValue("proxyAddresses")))ExpressionUpdate
pwdLastSetIIF(IsPresent([pwdLastSet]),CStr(FormatDateTime(DateFromNum([pwdLastSet]),"yyyyMMddHHmmss.0Z")),NULL)ExpressionUpdate
snTrim([sn])ExpressionUpdate
sourceAnchorIIF(IsPresent([msExchRecipientTypeDetails]),IIF([msExchRecipientTypeDetails]=2,NULL,IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID]))),IIF(IsString([objectGUID]),CStr([objectGUID]),ConvertToBase64([objectGUID])))ExpressionUpdate
sourceObjectTypeIIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User")ExpressionUpdate
stTrim([st])ExpressionUpdate
streetAddressTrim([streetAddress])ExpressionUpdate
telephoneNumberTrim([telephoneNumber])ExpressionUpdate
thumbnailPhotothumbnailPhotoDirectUpdate
titleTrim([title])ExpressionUpdate
urlIIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448))ExpressionUpdate
userPrincipalNameIIF(IsPresent([userPrincipalName]),[userPrincipalName], IIF(IsPresent([sAMAccountName]),([sAMAccountName]&"@"&%Domain.FQDN%),Error("AccountName is not present")))ExpressionUpdate
wWWHomePageTrim([wWWHomePage])ExpressionUpdate
In from AD - User Common from Exchange
Description
SettingConfiguration
NameIn from AD - User Common from Exchange
DescriptionAttributes from the forest where the user has an Exchange mailbox.
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeJoin
Precedence104
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADUserCommonfromExchange.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1mailNicknameISNOTNULL
1adminDescriptionNOTSTARTSWITHUser_
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
accountEnabledIIF(BitAnd([userAccountControl],2)=0,True,False)ExpressionUpdate
accountNamesAMAccountNameDirectUpdate
assistantassistantDirectUpdate
cTrim([c])ExpressionUpdate
cncnDirectUpdate
coTrim([co])ExpressionUpdate
companyTrim([company])ExpressionUpdate
countryCodecountryCodeDirectUpdate
departmentTrim([department])ExpressionUpdate
descriptionIIF(IsNullOrEmpty([description]),NULL,Left(Trim(Item([description],1)),448))ExpressionUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
facsimileTelephoneNumberTrim([facsimileTelephoneNumber])ExpressionUpdate
givenNameTrim([givenName])ExpressionUpdate
homePhoneTrim([homePhone])ExpressionUpdate
infoLeft(Trim([info]),448)ExpressionUpdate
initialsTrim([initials])ExpressionUpdate
ipPhoneTrim([ipPhone])ExpressionUpdate
lTrim([l])ExpressionUpdate
mailTrim([mail])ExpressionUpdate
managermanagerDirectUpdate
middleNameTrim([middleName])ExpressionUpdate
mobileTrim([mobile])ExpressionUpdate
otherFacsimileTelephoneNumberTrim([otherFacsimileTelephoneNumber])ExpressionUpdate
otherHomePhoneTrim([otherHomePhone])ExpressionUpdate
otherIpPhoneTrim([otherIpPhone])ExpressionUpdate
otherMobileTrim([otherMobile])ExpressionUpdate
otherPagerTrim([otherPager])ExpressionUpdate
otherTelephoneTrim([otherTelephone])ExpressionUpdate
pagerTrim([pager])ExpressionUpdate
photophotoDirectUpdate
physicalDeliveryOfficeNameTrim([physicalDeliveryOfficeName])ExpressionUpdate
postalCodeTrim([postalCode])ExpressionUpdate
postOfficeBoxIIF(IsNullOrEmpty([postOfficeBox]),NULL,Left(Trim(Item([postOfficeBox],1)),448))ExpressionUpdate
preferredLanguageTrim([preferredLanguage])ExpressionUpdate
proxyAddressesRemoveDuplicates(Trim(ImportedValue("proxyAddresses")))ExpressionUpdate
snTrim([sn])ExpressionUpdate
sourceObjectTypeIIF(IsPresent([msExchRecipientTypeDetails]), IIF([msExchRecipientTypeDetails]=2, NULL, "User"), "User")ExpressionUpdate
stTrim([st])ExpressionUpdate
streetAddressTrim([streetAddress])ExpressionUpdate
telephoneNumberTrim([telephoneNumber])ExpressionUpdate
thumbnailPhotothumbnailPhotoDirectUpdate
titleTrim([title])ExpressionUpdate
urlIIF(IsNullOrEmpty([url]),NULL,Left(Trim(Item([url],1)),448))ExpressionUpdate
wWWHomePageTrim([wWWHomePage])ExpressionUpdate
In from AD - User Exchange
Description
SettingConfiguration
NameIn from AD - User Exchange
DescriptionUser object with Exchange schema in Active Directory.
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeJoin
Precedence108
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADUserExchange.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1mailNicknameISNOTNULL
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
authOrigauthOrigDirectUpdate
contributingConnectorExchange%Connector.ID%ExpressionUpdate
dLMemRejectPermsdLMemRejectPermsDirectUpdate
dLMemSubmitPermsdLMemSubmitPermsDirectUpdate
extensionAttribute1Trim([extensionAttribute1])ExpressionUpdate
extensionAttribute10Trim([extensionAttribute10])ExpressionUpdate
extensionAttribute11Trim([extensionAttribute11])ExpressionUpdate
extensionAttribute12Trim([extensionAttribute12])ExpressionUpdate
extensionAttribute13Trim([extensionAttribute13])ExpressionUpdate
extensionAttribute14Trim([extensionAttribute14])ExpressionUpdate
extensionAttribute15Trim([extensionAttribute15])ExpressionUpdate
extensionAttribute2Trim([extensionAttribute2])ExpressionUpdate
extensionAttribute3Trim([extensionAttribute3])ExpressionUpdate
extensionAttribute4Trim([extensionAttribute4])ExpressionUpdate
extensionAttribute5Trim([extensionAttribute5])ExpressionUpdate
extensionAttribute6Trim([extensionAttribute6])ExpressionUpdate
extensionAttribute7Trim([extensionAttribute7])ExpressionUpdate
extensionAttribute8Trim([extensionAttribute8])ExpressionUpdate
extensionAttribute9Trim([extensionAttribute9])ExpressionUpdate
legacyExchangeDNlegacyExchangeDNDirectUpdate
mailNicknamemailNicknameDirectUpdate
msDS-HABSeniorityIndexmsDS-HABSeniorityIndexDirectUpdate
msDS-PhoneticDisplayNamemsDS-PhoneticDisplayNameDirectUpdate
msExchArchiveGUIDmsExchArchiveGUIDDirectUpdate
msExchArchiveNamemsExchArchiveNameDirectUpdate
msExchAssistantNamemsExchAssistantNameDirectUpdate
msExchBlockedSendersHashmsExchBlockedSendersHashDirectUpdate
msExchBypassModerationFromDLMembersLinkmsExchBypassModerationFromDLMembersBLDirectUpdate
msExchBypassModerationLinkmsExchBypassModerationLinkDirectUpdate
msExchDelegateListLinkmsExchDelegateListLinkDirectUpdate
msExchELCExpirySuspensionEndmsExchELCExpirySuspensionEndDirectUpdate
msExchELCExpirySuspensionStartmsExchELCExpirySuspensionStartDirectUpdate
msExchELCMailboxFlagsmsExchELCMailboxFlagsDirectUpdate
msExchEnableModerationmsExchEnableModerationDirectUpdate
msExchHideFromAddressListsmsExchHideFromAddressListsDirectUpdate
msExchImmutableIdmsExchImmutableIdDirectUpdate
msExchMailboxGuidmsExchMailboxGuidDirectUpdate
msExchMasterAccountSidmsExchMasterAccountSidDirectUpdate
msExchModeratedByLinkmsExchModeratedByLinkDirectUpdate
msExchModerationFlagsmsExchModerationFlagsDirectUpdate
msExchRecipientDisplayTypemsExchRecipientDisplayTypeDirectUpdate
msExchRecipientTypeDetailsmsExchRecipientTypeDetailsDirectUpdate
msExchRequireAuthToSendTomsExchRequireAuthToSendToDirectUpdate
msExchResourceCapacitymsExchResourceCapacityDirectUpdate
msExchResourceDisplaymsExchResourceDisplayDirectUpdate
msExchResourceMetaDatamsExchResourceMetaDataDirectUpdate
msExchResourceSearchPropertiesmsExchResourceSearchPropertiesDirectUpdate
msExchRetentionCommentmsExchRetentionCommentDirectUpdate
msExchRetentionURLmsExchRetentionURLDirectUpdate
msExchSafeRecipientsHashmsExchSafeRecipientsHashDirectUpdate
msExchSafeSendersHashmsExchSafeSendersHashDirectUpdate
msExchSenderHintTranslationsmsExchSenderHintTranslationsDirectUpdate
publicDelegatespublicDelegatesDirectUpdate
targetAddresstargetAddressDirectUpdate
telephoneAssistantTrim([telephoneAssistant])ExpressionUpdate
unauthOrigunauthOrigDirectUpdate
userCertificateuserCertificateDirectUpdate
userSMIMECertificateuserSMIMECertificateDirectUpdate
In from AD - User Join
Description
SettingConfiguration
NameIn from AD - User Join
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeProvision
Precedence100
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADUserJoin.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1isCriticalSystemObjectNOTEQUALTRUE
1adminDescriptionNOTSTARTSWITHUser_
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDsourceAnchorBinary
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
cloudFilteredIIF(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)ExpressionUpdate
sourceAnchorBinaryobjectGUIDDirectUpdate
In from AD - Computer Join
Description
SettingConfiguration
NameIn from AD - Computer Join
Description
DirectionInbound
Connected Systemcontoso.com
Connected System Object Typecomputer
Metaverse Object Typedevice
Link TypeProvision
Precedence156
Soft Delete Expiry Interval00:00:00
TagMicrosoft.InfromADComputerJoin.001
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
1objectGUIDdeviceId
Transformations
Target (MV) AttributeSourceFlow TypeApply OnceMerge Type
-----
accountEnabledIIF(BitAnd([userAccountControl],2)=0,True,False)ExpressionUpdate
cloudCreatedCBool(0)ExpressiontrueUpdate
cloudFilteredIIF(IsNullOrEmpty([userCertificate]),True,NULL)ExpressionUpdate
deviceIdobjectGUIDDirectUpdate
deviceOSTypeoperatingSystemDirectUpdate
deviceOSVersionoperatingSystemVersionDirectUpdate
deviceTrustTypeServerAdConstantUpdate
displayNameIIF(IsNullOrEmpty([displayName]),[cn],[displayName])ExpressionUpdate
objectSidobjectSidDirectUpdate
registeredOwnerReferencemS-DS-CreatorSIDDirecttrueUpdate
sourceAnchorConvertToBase64([objectGUID])ExpressionUpdate
sourceObjectTypeComputerConstantUpdate
userCertificateuserCertificateDirectUpdate

Outbound

Out to AD - Contact Exchange Hybrid
Description
SettingConfiguration
NameOut to AD - Contact Exchange Hybrid
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object Typecontact
Metaverse Object Typeperson
Link TypeJoin
Precedence152
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADContactExchangeHybrid.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
proxyAddressesIIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN])ExpressionMergeCaseInsensitive
Out to AD - Contact Join
Description
SettingConfiguration
NameOut to AD - Contact Join
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object Typecontact
Metaverse Object Typeperson
Link TypeJoin
Precedence148
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADContactJoin.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1mailmail
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
-----
Out to AD - Group Exchange Hybrid
Description
SettingConfiguration
NameOut to AD - Group Exchange Hybrid
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object Typegroup
Metaverse Object Typegroup
Link TypeJoin
Precedence153
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADGroupExchangeHybrid.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1cloudMasteredNOTEQUALTrue
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
proxyAddressesIIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN])ExpressionMergeCaseInsensitive
Out to AD - Group Join
Description
SettingConfiguration
NameOut to AD - Group Join
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object Typegroup
Metaverse Object Typegroup
Link TypeJoin
Precedence149
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADGroupJoin.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1cloudMasteredNOTEQUALTrue
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDsourceAnchorBinary
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
-----
Out to AD - InetOrgPerson Exchange Hybrid
Description
SettingConfiguration
NameOut to AD - InetOrgPerson Exchange Hybrid
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeJoin
Precedence154
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADInetOrgPersonExchangeHybrid.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1contributingConnectorExchangeEQUAL%Connector.ID%
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
msExchBlockedSendersHashIIF([cloudSOAExchMailbox] = True,[cloudMSExchBlockedSendersHash],IgnoreThisFlow)ExpressionUpdate
msExchSafeRecipientsHashIIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeRecipientsHash],IgnoreThisFlow)ExpressionUpdate
msExchSafeSendersHashIIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeSendersHash],IgnoreThisFlow)ExpressionUpdate
proxyAddressesIIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN])ExpressionMergeCaseInsensitive
Out to AD - InetOrgPerson Join
Description
SettingConfiguration
NameOut to AD - InetOrgPerson Join
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object TypeinetOrgPerson
Metaverse Object Typeperson
Link TypeJoin
Precedence150
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADInetOrgPersonJoin.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDsourceAnchorBinary
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
-----
Out to AD - User Exchange Hybrid
Description
SettingConfiguration
NameOut to AD - User Exchange Hybrid
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeJoin
Precedence155
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADUserExchangeHybrid.003
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
----
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
----
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
msExchBlockedSendersHashIIF([cloudSOAExchMailbox] = True,[cloudMSExchBlockedSendersHash],IgnoreThisFlow)ExpressionUpdate
msExchSafeRecipientsHashIIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeRecipientsHash],IgnoreThisFlow)ExpressionUpdate
msExchSafeSendersHashIIF([cloudSOAExchMailbox] = True,[cloudMSExchSafeSendersHash],IgnoreThisFlow)ExpressionUpdate
proxyAddressesIIF(IsNullOrEmpty([cloudLegacyExchangeDN]),NULL,"x500:" & [cloudLegacyExchangeDN])ExpressionMergeCaseInsensitive
Out to AD - User Join
Description
SettingConfiguration
NameOut to AD - User Join
Description
DirectionOutbound
Connected Systemcontoso.com
Connected System Object Typeuser
Metaverse Object Typeperson
Link TypeJoin
Precedence151
Soft Delete Expiry Interval00:00:00
TagMicrosoft.OuttoADUserJoinSOAInAD.004
Enable Password SyncNo
Scoping Filter
Group#AttributeOperatorValue
1cloudMasteredEQUALFalse
Join Rules
Group#Source AttributeTarget AttributeCase Sensitive
1objectGUIDsourceAnchorBinary
Transformations
Target (CS) AttributeSourceFlow TypeApply OnceMerge Type
-----