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.

Set the filtering conditions to hide unwanted data based on criteria not supported in the Query criteria setting.

Example: filter by the found object Distinguished Name.

TIP: For optimal performance, use the Query criteria setting above to filter objects whenever possible.

Initialization Script

The Email address to which the invitation is sent.

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

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 Administrator for an override format.  

Settings

Specify the usage location.

Specify invited guest user account status. 

Specify if to send an invitation email to the invited guest user.

You can specify a personal message that will be sent to the invited guest user.

The URL to which the invited user is forwarded after accepting the invitation.

Organization

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

Contact Info