Import SQL Data | Create AD Users with Remote Linked Mailbox rule

Logon name (SamAccountName)

By default, the SamAccountName is automatically generated from the Data Source assuming the Data Source contains the correct named fields.

If field names are not the same as shown for the selected format, contact Cayosoft for an override format.

The SamAccountName must have a unique value in the target domain.

UPNSuffix (@domain.com)

It is the domain name component of the new user’s UserPrincipalName (UPN).

The default UPN suffix is defined in the Default domain setting in AD Users web query.

If you are using Office 365, this value should be set to a domain that has been registered in Office 365/Azure AD.

UserPrincipalName

By default, the UserPrincipalName (UPN)  is automatically generated from the Data Source assuming the Data Source contains the correctly named fields. If field names are not the same as shown for the selected UPN format, contact Cayosoft for an override format. The UPN must be a unique value.

FirstName (GivenName)

If the Data Source contains a field named FirstName, do nothing. Otherwise, use the Selector button to choose a field from the Data Source. 

Initials

Last/SurName (sn)

Name (cn)

If the Data Source contains fields named FirstName and LastName, choose the desired format or do nothing. 

Display Name

Description

If the Data Source contains a field name Description, do nothing. Otherwise, manually enter a static text value or use the Selector button to choose a field from the Data Source. 

Name conflict resolution

This option determines how the system should react when the name of a user being created already exists.

Logon Name (SamAccountName) (Alternative)

UserPrincipalName (Alternative)

Name (cn) (Alternative)

Email Address (Alternative)

DisplayName (Alternative)

The behavior of this attribute is the same as in the Contact Info section.

Counter format

This setting specifies the number of fixed symbols the counter should have.

Add counter when

Specifies if a counter should always be added to the username, or only when name conflicts occur. 

Mailbox Account Organization Properties

Office

Job Title (Title)

Department

Company

Employee Number

EmployeeID

Division

If the Data Source contains one of these field names, do nothing. Otherwise, manually enter a static text value or use the Selector button to choose a field from the Data Source.

Manager identifier

Use the Selector button to choose a field from the Data Source that is a unique identifier for the user’s manager. Typically this will be the Managers EmployeeNumber or EmployeeID.

AD attribute for manager lookup

Select an Active Directory attribute that is used to search for the value of the Manager Identifier specified in the field above.

Mailbox Account Contact Properties

Country

Specify the user country. By default, the value is taken from Active Directory extension.

Email address

Specify the format for email address.

Office phone (telephoneNumber)

Mobile phone (mobile)

Street address

City (l)

State

Postal code

If the Data Source contains a field with one of these names, do nothing. Otherwise manually enter a static text value or use the Selector button to choose a field from the Data Source.

Mailbox Account Other Properties

Other Properties

If you want every provisioned user to have extension attribute 1 populated with some string value then use this:
{@{'extensionAttribute1'='YourString'}}

If you want every provisioned user to have extension attribute 2 populated with the corresponding value from the column in your data source, then use this:
{@{'extensionAttribute2'=$_.EXT2}}, since EXT2 is the name of the column from your data source.

Master account UPNSuffix (@domain.com)

By default, the first value is taken from the Trusted Domains table in Active Directory extension.

Master account Logon name (SamAccountName)

Specify master account naming properties. By default, they are taken from mailbox account.

Master account UserPrincipalName

Master account FirstName (GivenName)

Master account Initials

Master account Last/SurName (sn)

Master account Name (cn)

Master account Display Name

Master Account Logon Settings

Default Password

This setting defines the password for the new account. This value can be static text, a field from the Data Source chosen using the Selection button, or set to Generate Random Password

Must change password at next logon

Account enabled

User cannot change password

Password never expires

These settings enable/disable the standard Active Directory user object settings. 

Account Expiration Date

This setting defines the Account Expiration attribute in Active Directory.

In addition to populating this field from the Data Source, a text string can also be manually entered into the field in the format MM/DD/YYYY or YYYY-MM-DD. 

Master Account Other Properties

Other Properties

If you want every provisioned user to have extension attribute 1 populated with some string value then use this:
{@{'extensionAttribute1'='YourString'}}

If you want every provisioned user to have extension attribute 2 populated with the corresponding value from the column in your data source, then use this:
{@{'extensionAttribute2'=$_.EXT2}}, since EXT2 is the name of the column from your data source.

Remote Mailbox Settings

Remote Routing Address

Specify the format for remote routing address.

Enable automatic email address updates by address policy

By default, Exchange contains an email address policy for every mail-enabled object. For more information, please see this article https://docs.microsoft.com/en-us/exchange/email-address-policies-exchange-2013-help.

If the Exchange address policy is applied, it generates email addresses automatically. By default, this policy is not enabled, Cayosoft Administrator generates the email address by itself.

Enable in-place archive

Select Yes to create an in-place archive mailbox.

Notify Manager

Notify Manager

Specify whether you want to notify the manager when the user is created. You can also select send email for each created user or send one email for all created users.  

Additional to

Additional email can be sent to Default Notify & Alert Email Address - usually, this is the administrator's email address.

CC, BCC

Email address where the copy will be sent.

From

Users can receive emails from default SMTP from address.

Subject

Email subject.

Message

Message text.

Limit the number of emails sent per minute

An integer value that represents the number of emails sent per minute by this rule.

To change the default value, navigate to Home > Configuration > Settings > Email Settings (SMTP).

The default limit for Office 365 SMTP gate is 30 emails per minute.