Data import

Connection details

Parameter	Value
Server Type	Hybrid
Local: Connection URI	https://[hostname]/powershell
Local: Authentication	Basic
Local: Username	Username
Local: Password	Password
Local: Session options	-SkipCACheck -SkipCNCheck -SkipRevocationCheck
Cloud: Authentication	Certificate with password
Cloud: Organization	[Organization
Cloud: Application ID	[Application ID]
Cloud: Certificate (PEM format)	-----BEGIN CERTIFICATE----- [Certificate] -----END CERTIFICATE-----
Cloud: Private key (PEM format)	-----BEGIN CERTIFICATE----- [Private key] -----END CERTIFICATE-----
Cloud: Private key password	[Private key password]
Test connection	Select the checkbox

Queries and mappings

The connectivity package provides the following mappings:

Generic Resources - Resource

Registers various types of Exchange-related mailboxes as generic resources in Omada, such as user mailboxes, discovery mailboxes, group mailboxes, scheduling mailboxes, and mailbox access entries (full access, send as, and send on behalf).

Parameters:

Parameter	Value
Source	Generic resources
Query scope	Local
Distinct	Yes
Filter	Type != "Exchange Equipment Mailbox" && Type != "Exchange Room Mailbox" && Type != "Exchange Shared Mailbox"
Description	Generic resources

Mappings:

Destination	Operator	Source
Business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName, BusinessKey)
Security resource business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName, BusinessKey)
Name	Map	Name
Category	Map	Category
Type	Map	Type
Short name	Expression	string.Format("{0}_{1}", BuiltIn.SystemShortName, BusinessKey)
Logical key	Expression	string.Format("{0}_{1}", BuiltIn.SystemShortName, BusinessKey)

Shared Mailbox, Equipment Mailbox, Room Mailbox – Full Access – Resource

Retrieves Exchange Hybrid shared, room and equipment mailboxes with full access permissions. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names.

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local and Cloud
Mailbox subtype	EquipmentMailbox, RoomMailbox, SharedMailbox
Distinct	Yes
Description	SharedMailbox, EquipmentMailbox, RoomMailbox - FullAccess

Mappings:

Destination	Operator	Source
Business key	Expression	ExchangeGuid + "_FullAccess"
Security resource business key	Expression	ExchangeGuid + "_FullAccess"
Name	Expression	DisplayName + "_FullAccess" + "_" + (ServerName == "exchange-ps" || ServerName == "exchange-local" ? "Local" : "Cloud")
Category	Constant	Permission
Type	Expression	RecipientTypeDetails == "EquipmentMailbox" ? "Exchange Equipment Mailbox" : RecipientTypeDetails == "RoomMailbox" ? "Exchange Room Mailbox" : RecipientTypeDetails == "SharedMailbox" ? "Exchange Shared Mailbox" : null
Short Name	Expression	DisplayName + "_FullAccess" + "_" + (ServerName == "exchange-ps" || ServerName == "exchange-local" ? "Local" : "Cloud")
Logical key	Expression	string.Format("<exchangeguid>{0}</exchangeguid>", DisplayName)
RecipientTypeDetails	Map	RecipientTypeDetails
PrimarySmtpAddress	Map	PrimarySmtpAddress
Identity	Map	Identity

Shared Mailbox, Equipment Mailbox, Room Mailbox – Send As – Resource

Retrieves Exchange Hybrid shared, room, and equipment mailboxes with send as permissions. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names.

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local and Cloud
Mailbox subtype	EquipmentMailbox, RoomMailbox, SharedMailbox
Distinct	Yes
Description	SharedMailbox, EquipmentMailbox, RoomMailbox - SendAs

Mappings:

Destination	Operator	Source
Business key	Expression	ExchangeGuid + "_SendAs"
Security resource business key	`Expression	ExchangeGuid + "_SendAs"`
Name	Expression	DisplayName + "_SendAs" + "_" + (ServerName == "exchange-ps" || ServerName == "exchange-local" ? "Local" : "Cloud")
Category	Constant	Permission
Type	Expression	RecipientTypeDetails == "EquipmentMailbox" ? "Exchange Equipment Mailbox" : RecipientTypeDetails == "RoomMailbox" ? "Exchange Room Mailbox" : RecipientTypeDetails == "SharedMailbox" ? "Exchange Shared Mailbox" : null
Short Name	Expression	DisplayName + "_SendAs" + "_" + (ServerName == "exchange-ps" || ServerName == "exchange-local" ? "Local" : "Cloud")
Description	Map	DisplayName
RecipientTypeDetails	Map	RecipientTypeDetails
PrimarySmtpAddress	Map	PrimarySmtpAddress
Identity	Map	Identity

Shared Mailbox, Equipment Mailbox, Room Mailbox – Send on Behalf – Resource

Retrieves Exchange Hybrid shared, room, and equipment mailboxes with send on behalf permissions. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names.

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local and Cloud
Mailbox subtype	EquipmentMailbox, RoomMailbox, SharedMailbox
Distinct	Yes
Description	SharedMailbox, EquipmentMailbox, RoomMailbox - SendOnBehalf

Mappings:

Destination	Operator	Source
Business key	Expression	ExchangeGuid + "_SendOnBehalf"
Security resource business key	Expression	ExchangeGuid + "_SendOnBehalf"
Name	Expression	DisplayName + "_SendOnBehalf" + "_" + (ServerName == "exchange-ps" || ServerName == "exchange-local" ? "Local" : "Cloud")
Category	Constant	Permission
Type	Expression	RecipientTypeDetails == "EquipmentMailbox" ? "Exchange Equipment Mailbox" : RecipientTypeDetails == "RoomMailbox" ? "Exchange Room Mailbox" : RecipientTypeDetails == "SharedMailbox" ? "Exchange Shared Mailbox" : null
Short Name	Expression	DisplayName + "_SendOnBehalf" + "_" + (ServerName == "exchange-ps" || ServerName == "exchange-local" ? "Local" : "Cloud")
Description	Map	DisplayName
RecipientTypeDetails	Map	RecipientTypeDetails
PrimarySmtpAddress	Map	PrimarySmtpAddress
Identity	Map	Identity

Administrative resources – Resource

This mapping creates administrative resources in Omada using data retrieved from Exchange Hybrid. It includes basic attributes of each group and can be extended with additional fields when needed.

Parameters:

Parameter	Value
Source	Administrative resources
Query scope	Local and Cloud
Filter	Type=="RoleGroups"
Description	Role Groups

Mappings:

Destination	Operator	Source
Business key	Expression	string.Format("<system>{0}</system><resource>{1}</resource>",BuiltIn.SystemShortName, RoleGroupSamAccountName.ToLower() )
Security resource business key	Expression	string.Format("<system>{0}</system><resource>{1}</resource>",BuiltIn.SystemShortName, RoleGroupSamAccountName.ToLower() )
Name	Map	RoleGroupName
Category	Constant	Group
Type	Constant	Exchange Admin Role Group
Short Name	Expression	string.Format("{0}_{1}", BuiltIn.SystemShortName, RoleGroupName)
Logical key	Expression	string.Format("{0}_{1}", BuiltIn.SystemShortName, RoleGroupName)
Distinguished name	Map	RoleDistinguishedName
Description	Map	RoleGroupDescription
Scope	Map	Scope
RoleGroupType	Map	RoleGroupType

Distribution Groups – Resource

Creates distribution group resources in Omada using data retrieved from Exchange Hybrid. It includes basic attributes of each group and can be extended with additional fields when needed. To map new attributes, the source field name must follow the pattern 'DistributionGroup' + Exchange field name (example: DistributionGroupType).

Parameters:

Parameter	Value
Source	Distribution Groups
Query scope	Cloud
Filter	Type=="DistributionGroups"
Description	Distribution Groups

Mappings:

Destination	Operator	Source
Business key	Map	DistributionGroupGuid
Security resource business key	Map	DistributionGroupGuid
Name	Map	DistributionGroupName
Category	Constant	Permission
Type	Constant	Exchange Distribution Group
Display name	Map	DistributionGroupDisplayName
Short Name	Map	DistributionGroupName
Logical key	Expression	!string.IsNullOrEmpty(DistributionGroupCustomAttribute1) ? DistributionGroupCustomAttribute1 : DistributionGroupGuid
Distinguished name	Map	DistributionGroupDistinguishedName
DistributionGroupType	Map	DistributionGroupType

Local User Mailbox – Resource Assignments

Establishes the relationship between users and their associated user mailboxes in Exchange Hybrid (Local). It ensures that each mailbox is correctly linked to its corresponding user account in Omada. To include additional attributes, add the field using the exact name from Exchange (example: to map the Identity field, use Identity as the source name).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local
Mailbox subtype	UserMailbox,LinkedMailbox
Filter	Type=="User mailbox"
Description	Local user mailboxes assignments

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName,RecipientTypeDetails)
Account - CBK	Lookup	Path=Identity
Business key	Expression	Type=="User mailbox"?"<exchangeguid>"+ExchangeGuid+"</exchangeguid>":null
PRIMARY_EMAIL	Map	PrimarySmtpAddress
ADDITIONAL_EMAILS	Map	EmailAddresses
HIDEINADDRESSLIST	Map	HiddenFromAddressListsEnabled
ISSUEWARNINGQUOTA	Map	IssueWarningQuota
PROHIBITSENDQUOTA	Map	ProhibitSendQuota
PROHIBITSENDRECEIVEQUOTA	Map	ProhibitSendReceiveQuota
WEBMAIL	Map	OWAEnabled
MAILBOXLOCATION	Map	MailboxLocation

Online User Mailbox – Resource Assignments

Establishes the relationship between users and their associated user mailboxes in Exchange Hybrid (Online). It ensures that each mailbox is correctly linked to its corresponding user account in Omada. To include additional attributes, add the field using the exact name from Exchange (example: to map the Identity field, use Identity as the source name).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Cloud
Mailbox subtype	UserMailbox,LinkedMailbox
Filter	Type=="User mailbox"
Description	Online user mailboxes assignments

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName,RecipientTypeDetails)
Account - CBK	Lookup	BusinessKey=ExternalDirectoryObjectID
Business key	Expression	Type=="User mailbox"?"<exchangeguid>"+ExchangeGuid+"</exchangeguid>":null
PRIMARY_EMAIL	Map	PrimarySmtpAddress
ADDITIONAL_EMAILS	Map	EmailAddresses
HIDEINADDRESSLIST	Map	HiddenFromAddressListsEnabled
ISSUEWARNINGQUOTA	Map	IssueWarningQuota
PROHIBITSENDQUOTA	Map	ProhibitSendQuota
PROHIBITSENDRECEIVEQUOTA	Map	ProhibitSendReceiveQuota
WEBMAIL	Map	OWAEnabled
MAILBOXLOCATION	Map	MailboxLocation

Local mailboxes - DiscoveryMailbox, GroupMailbox, LegacyMailbox, LinkedMailbox, LinkedRoomMailbox, SchedulingMailbox, TeamMailbox – Resource Assignments

Creates user-to-resource assignments in Omada for Exchange Hybrid generic mailboxes, including Discovery, Group, and Scheduling Mailboxes. It links each mailbox to its respective user(s). To include additional attributes, add the field using the exact name from Exchange (example: to map the Identity field, use Identity as the source name).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local
Mailbox subtype	DiscoveryMailbox, GroupMailbox, LegacyMailbox, LinkedMailbox, LinkedRoomMailbox, SchedulingMailbox, TeamMailbox
Filter	Identity != null && Type !="Full access" && Type !="Send as" && Type !="Send on behalf"
Description	Local mailboxes - DiscoveryMailbox, GroupMailbox, LegacyMailbox, LinkedMailbox, LinkedRoomMailbox, SchedulingMailbox, TeamMailbox

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName,RecipientTypeDetails)
Account – CBK	Lookup	Path=Identity
Business key	Expression	Type=="Usermailbox"?"<exchangeguid>"+ExchangeGuid+"</exchangeguid>":null
PRIMARY_EMAIL	Map	PrimarySmtpAddress
ADDITIONAL_EMAILS	Map	EmailAddresses
HIDEINADDRESSLIST	Map	HiddenFromAddressListsEnabled
ISSUEWARNINGQUOTA	Map	IssueWarningQuota
PROHIBITSENDQUOTA	Map	ProhibitSendQuota
PROHIBITSENDRECEIVEQUOTA	Map	ProhibitSendReceiveQuota
WEBMAIL	Map	OWAEnabled
LinkedMasterAccount	Map	LinkedMasterAccount
MailboxLocation	Map	MailboxLocation

Online mailboxes - DiscoveryMailbox, GroupMailbox, LegacyMailbox, LinkedMailbox, LinkedRoomMailbox, SchedulingMailbox, TeamMailbox – Resouce Assignments

Creates user-to-resource assignments in Omada for Exchange Hybrid generic mailboxes, including Discovery, Group, and Scheduling Mailboxes. It links each mailbox to its respective user(s). To include additional attributes, add the field using the exact name from Exchange (example: to map the Identity field, use Identity as the source name).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Cloud
Mailbox subtype	DiscoveryMailbox, GroupMailbox, LegacyMailbox, LinkedMailbox, LinkedRoomMailbox, SchedulingMailbox, TeamMailbox
Filter	Identity != null && Type !="Full access" && Type !="Send as" && Type !="Send on behalf"
Description	Online mailboxes - DiscoveryMailbox, GroupMailbox, LegacyMailbox, LinkedMailbox, LinkedRoomMailbox, SchedulingMailbox, TeamMailbox

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName,RecipientTypeDetails)
Account – CBK	Lookup	BusinessKey=ExternalDirectoryObjectID
Business key	Expression	Type=="Usermailbox"?"<exchangeguid>"+ExchangeGuid+"</exchangeguid>":null
PRIMARY_EMAIL	Map	PrimarySmtpAddress
ADDITIONAL_EMAILS	Map	EmailAddresses
HIDEINADDRESSLIST	Map	HiddenFromAddressListsEnabled
ISSUEWARNINGQUOTA	Map	IssueWarningQuota
PROHIBITSENDQUOTA	Map	ProhibitSendQuota
PROHIBITSENDRECEIVEQUOTA	Map	ProhibitSendReceiveQuota
WEBMAIL	Map	OWAEnabled
LinkedMasterAccount	Map	LinkedMasterAccount
MailboxLocation	Map	MailboxLocation

Local mailbox access (UserMailbox, LinkedMailbox) – Resource Assignments

Retrieves Exchange Hybrid UserMailbox and LinkedMailbox with the users (local). It links each mailbox to its respective user(s). Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailbox access
Query scope	Local
Mailbox subtype	UserMailbox,LinkedMailbox
Filter	LinkedMasterAccount != null && LinkedMasterAccount != "NT AUTHORITY"
Description	Local mailbox access

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>{1}</genericresource>",BuiltIn.SystemShortName, Type == "Full access" ? "fullmailboxaccess": "sendasmailboxaccess")
Account - CBK	Lookup	Name=LinkedMasterAccount
Target – CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)`
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", LinkedMasterAccount, Type, ExchangeGuid)
LinkedMasterAccount	Map	LinkedMasterAccount
AccessType	Map	Type
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Local Shared Mailbox, Equipment Mailbox, Room Mailbox (Full Access) – Resource Assignments

Retrieves Exchange Hybrid shared, room, and equipment Mailbox Access along with the users who have been granted full access permissions. It creates the corresponding resource assignments in Omada to reflect these delegated access rights. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailbox access
Query scope	Local
Mailbox subtype	EquipmentMailbox,RoomMailbox,SharedMailbox
Filter	LinkedMasterAccount != null && LinkedMasterAccount != "NT AUTHORITY" && Type == "Full access"
Description	Local mailbox access- FullAccess

Mappings:

Destination	Operator	Source
Resource Business key	Expression	ExchangeGuid + "_FullAccess"
Account - CBK	Lookup	Name=LinkedMasterAccount
Target – CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", LinkedMasterAccount, Type, ExchangeGuid)
LinkedMasterAccount	Map	LinkedMasterAccount
AccessType	Map	Type
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Local Shared Mailbox, Equipment Mailbox, Room Mailbox (Send as) – Resource Assignments

Retrieves Exchange Hybrid shared, room, and equipment Mailbox Access along with the users who have been granted full access permissions. It creates the corresponding resource assignments in Omada to reflect these delegated access rights. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailbox access
Query scope	Local
Mailbox subtype	EquipmentMailbox,RoomMailbox,SharedMailbox
Filter	LinkedMasterAccount != null && LinkedMasterAccount != "NT AUTHORITY" && Type == "Send as"
Description	Local mailbox access- SendAs

Mappings:

Destination	Operator	Source
Resource Business key	Expression	ExchangeGuid + "_SendAs"
Account - CBK	Lookup	Name=LinkedMasterAccount
Target – CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", LinkedMasterAccount, Type, ExchangeGuid)
LinkedMasterAccount	Map	LinkedMasterAccount
AccessType	Map	Type
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Online Shared Mailbox, Equipment Mailbox, Room Mailbox (Full Access) – Resource Assignments

This mapping retrieves Exchange Hybrid shared, room, and equipment Mailbox Access with the users who have been granted full access permissions. It creates the corresponding resource assignments in Omada to reflect these delegated access rights. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailbox access
Query scope	Cloud
Mailbox subtype	EquipmentMailbox,RoomMailbox,SharedMailbox
Filter	LinkedMasterAccount != null && LinkedMasterAccount != "NT AUTHORITY" && Type == "Full access"
Description	Online mailbox access - FullAccess

Mappings:

Destination	Operator	Source
Resource Business key	Expression	ExchangeGuid + "_FullAccess"
Account - CBK	Lookup	DistinguishedName=LinkedMasterAccount
Target – CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", LinkedMasterAccount, Type, ExchangeGuid)
LinkedMasterAccount	Map	LinkedMasterAccount
AccessType	Map	Type
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Online Shared Mailbox, Equipment Mailbox, Room Mailbox (SendAs) – Resource Assignments

Retrieves Exchange Hybrid shared, room, and equipment Mailbox Access along with the users who have been granted full access permissions. It creates the corresponding resource assignments in Omada to reflect these delegated access rights. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailbox access
Query scope	Cloud
Mailbox subtype	EquipmentMailbox,RoomMailbox,SharedMailbox
Filter	LinkedMasterAccount != null && LinkedMasterAccount != "NT AUTHORITY" && Type == "Send as"
Description	Online mailbox access - SendAs

Mappings:

Destination	Operator	Source
Resource Business key	Expression	ExchangeGuid + "_SendAs"
Account - CBK	Lookup	DistinguishedName=LinkedMasterAccount
Target – CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", LinkedMasterAccount, Type, ExchangeGuid)
LinkedMasterAccount	Map	LinkedMasterAccount
AccessType	Map	Type
Identity	Map	Identity
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Local mailboxes (Send on Behalf) – Resource Assignments

Creates user-to-resource assignments in Omada for Exchange Hybrid mailboxes, including Discovery, Group, and Scheduling Mailboxes. It links each mailbox to its respective user(s). To include additional attributes, add the field using the exact name from Exchange (example: to map the Identity field, use Identity as the source name).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local
Mailbox subtype	UserMailbox,LinkedMailbox,DiscoveryMailbox,GroupMailbox,LegacyMailbox,LinkedRoomMailbox,SchedulingMailbox,TeamMailbox
Filter	Type==”Send on behalf”
Description	Local send on behalf

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>sendonbehalfofmailboxaccess</genericresource>",BuiltIn.SystemShortName)
Account - CBK	Lookup	Path=GrantSendOnBehalfTo
Target - CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", GrantSendOnBehalfTo, Type, ExchangeGuid)
PRIMARY_EMAIL	Map	PrimarySmtpAddress
Identity	Map	Identity
RecipientTypeDetails	Map	RecipientTypeDetails
ExternalDirectoryObjectID	Map	ExternalDirectoryObjectID
GrantSendOnBehalfTo	Map	GrantSendOnBehalfTo
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Online mailboxes (Send on Behalf) – Resource Assignments

Creates user-to-resource assignments in Omada for Exchange Hybrid mailboxes, including Discovery, Group, and Scheduling Mailboxes. It links each mailbox to its respective user(s). To include additional attributes, add the field using the exact name from Exchange (example: to map the Identity field, use Identity as the source name).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Cloud
Mailbox subtype	UserMailbox,LinkedMailbox,DiscoveryMailbox,GroupMailbox,LegacyMailbox,LinkedRoomMailbox,SchedulingMailbox,TeamMailbox
Filter	Type==”Send on behalf”
Description	Online send on behalf

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><genericresource>sendonbehalfofmailboxaccess</genericresource>",BuiltIn.SystemShortName)
Account - CBK	Lookup	BusinessKey=GrantSendOnBehalfTo
Target - CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", GrantSendOnBehalfTo, Type, ExchangeGuid)
PRIMARY_EMAIL	Map	PrimarySmtpAddress
Identity	Map	Identity
RecipientTypeDetails	Map	RecipientTypeDetails
ExternalDirectoryObjectID	Map	ExternalDirectoryObjectID
GrantSendOnBehalfTo	Map	GrantSendOnBehalfTo
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Local shared Mailbox, Equipment Mailbox, Room Mailbox (Send on Behalf) – Resource Assignments

Retrieves Exchange Hybrid shared, room, and equipment mailboxes along with the users who have been granted Send on Behalf permissions. It creates the corresponding resource assignments in Omada to reflect these delegated access rights. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Local
Mailbox subtype	EquipmentMailbox,RoomMailbox,SharedMailbox
Filter	Type==”Send on behalf”
Description	Local send on behalf - equipment, room and shared mailboxes

Mappings:

Destination	Operator	Source
Resource Business key	Expression	ExchangeGuid + "_SendOnBehalf"
Account - CBK	Lookup	Path=GrantSendOnBehalfTo
Target - CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", GrantSendOnBehalfTo, Type, ExchangeGuid)
PRIMARY_EMAIL	Map	PrimarySmtpAddress
Identity	Map	Identity
RecipientTypeDetails	Map	RecipientTypeDetails
ExternalDirectoryObjectID	Map	ExternalDirectoryObjectID
GrantSendOnBehalfTo	Map	GrantSendOnBehalfTo
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Online shared Mailbox, Equipment Mailbox, Room Mailbox (Send on Behalf) – Resource Assignments

This mapping retrieves Exchange Hybrid shared, room, and equipment mailboxes along with the users who have been granted Send on Behalf permissions. It creates the corresponding resource assignments in Omada to reflect these delegated access rights. Additional fields available in Exchange Hybrid can be mapped by adding them directly to the mapping configuration using their original property names (example: Identity).

Parameters:

Parameter	Value
Source	Mailboxes
Query scope	Cloud
Mailbox subtype	EquipmentMailbox,RoomMailbox,SharedMailbox
Filter	Type==”Send on behalf”
Description	Online send on behalf - equipment, room and shared mailboxes

Mappings:

Destination	Operator	Source
Resource Business key	Expression	ExchangeGuid + "_SendOnBehalf"
Account - CBK	Lookup	BusinessKey=GrantSendOnBehalfTo
Target - CBK	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", GrantSendOnBehalfTo, Type, ExchangeGuid)
PRIMARY_EMAIL	Map	PrimarySmtpAddress
Identity	Map	Identity
RecipientTypeDetails	Map	RecipientTypeDetails
ExternalDirectoryObjectID	Map	ExternalDirectoryObjectID
GrantSendOnBehalfTo	Map	GrantSendOnBehalfTo
MAILBOXREF	Expression	string.Format("{0}_<exchangeguid>{1}</exchangeguid>", BuiltIn.SourceSystemID, ExchangeGuid)

Distribution Groups – Resource Assignments

Creates user-to-distribution group assignments in Omada based on membership data retrieved from Exchange Hybrid. It ensures that each user is correctly associated with the distribution groups they belong to. To map new attributes, the source field name must follow the pattern DistributionGroup + Exchange field name (example: DistributionGroupDistinguishedName).

Parameters:

Parameter	Value
Source	Distribution groups
Query scope	Cloud
Filter	Type=="DistributionGroupMembers"
Description	Online distribution groups members

Mappings:

Destination	Operator	Source
Resource Business key	Map	DistributionGroupGuid
Account - CBK	Lookup	BusinessKey=MemberExternalDirectoryObjectId
Description	Map	RecipientType

Local Administrative Resources – Resource Assignments

Creates assignments in Omada between users and their associated role groups in Exchange Hybrid. It ensures that each user is correctly linked to the role groups they belong to.

Parameters:

Parameter	Value
Source	Administrative resources
Query scope	Local
Filter	Type=="Members" && RecipientType?.ToString().IndexOf("Group") < 0
Description	Local role assignments

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><resource>{1}</resource>",BuiltIn.SystemShortName, RoleGroupSamAccountName.ToLower() )
Account - CBK	Lookup	DistinguishedName=MemberDistinguishedName
Description	Map	RecipientType

Online Administrative Resources – Resource Assignments

This mapping creates assignments in Omada between users and their associated role groups in Exchange Hybrid. It ensures that each user is correctly linked to the role groups they belong to.

Parameters:

Parameter	Value
Source	Administrative resources
Query scope	Cloud
Filter	Type=="Members" && RecipientType?.ToString().IndexOf("Group") < 0 && RecipientType =="UserMailbox"
Description	Online role assignments

Mappings:

Destination	Operator	Source
Resource Business key	Expression	string.Format("<system>{0}</system><resource>{1}</resource>",BuiltIn.SystemShortName, RoleGroupSamAccountName.ToLower() )
Account - CBK	Lookup	UID=MemberName
Business key	Expression	string.Format("<account>{0}</account><resource>{1}</resource><target>{2}</target>", MemberName, MemberRecipientTypeDetails, RoleGroupSamAccountName.ToLower())
Description	Map	RecipientType

Administrative Role – Resource Parent/Child

This mapping creates parent–child assignments in Omada between administrative roles and Exchange Hybrid shared, room, and equipment mailboxes. It reflects which roles are responsible for managing these resources. Depending on the role model, other resource types such as distribution groups can also be assigned if the role represents administrative ownership over those objects.

Parameters:

Parameter	Value
Source	Administrative resources
Query scope	Local and Cloud
Filter	Type=="Members" && RecipientType?.ToString().IndexOf("Group") !=-1
Description	Members group

Mappings:

Destination	Operator	Source
Indirect	Constant	0
Parent resource business key	Expression	string.Format("<system>{0}</system><resource>{1}</resource>",BuiltIn.SystemShortName, RoleGroupSamAccountName.ToLower() )
Child resource - business key	Lookup	DistinguishedName=MemberDistinguishedName