Specify the name of the SQL Instance as defined in the Utils Extension SQL Server configuration.

Using the Default SQL Instance setting will retrieve the current setting from the SQL Connection settings of the Utils extension.

NOTE: For more information, review the Connecting to Microsoft SQL Server data source article.

Specify database name from selected SQL Instance.

Specify an SQL Table or View from the selected database. Click the [...] button to display a list of tables from which to choose.

Specify the database from the data source SQL Instance. Click the [...] button to enter SQL Credentials.

NOTE: Cayosoft Administrator does not support Windows Authentication for connecting to a Microsoft SQL Server database. The database connection must use SQL Server Authentication, where the credentials (username and password) are created and managed within SQL Server itself. Mixed Mode refers to the SQL Server configuration that allows both SQL Server Authentication and Windows Authentication, but only SQL Server Authentication is supported by Cayosoft Administrator.

You can use the point-and-click filter builder for the specified data source.

NOTE: If the Where clause is also specified, it will be applied and DataSource Filter will be ignored.

Specify columns returned by the data source.

Define a WHERE statement in the SQL query sent to the data source to limit the rows returned by SQL Server.

Select properties to display for each object found by the query.

Specify UserPrincipalName generation format. UserPrincipalName must be a unique value.  

NOTE: Microsoft best practices assume the Active Directory and Microsoft 365/Entra ID UPNs will match. 

This value should be set to a domain that has been registered in Microsoft 365/Entra ID. 

The default value is taken from M365 user name suffix setting defined in Microsoft 365 extension settings.

If the Data Source contains a field named FirstName, ignore this setting. Otherwise, use the Selector button to choose a field from the Data Source. 

If the Data Source contains a field named LastName, ignore this setting. Otherwise, use the Selector button to choose a field from the Data Source. 

If the Data Source contains fields named FirstName and LastName, ignore this setting. Otherwise, use the Selector button to select a field from the Data Source or contact Cayosoft for an override format. 

Settings

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.

NOTE: Static passwords or passwords from the Data Source must meet the Active Directory Password Complexity Policy of the target container, or the account will be created in a disabled state. Randomly Generated Passwords will be generated to match both the Active Directory Password Complexity Policy and additional complexity requirements defined in the Cayosoft Administrator Password Complexity Policy. 

Specify if a user must change password at next logon.

Specify if a created user account will be enabled or disabled. 

Organization

Specify a static text value or use the Selector button to choose a field from the Data Source.