Using Domain Users and Groups with the SQL Repository

Revision as of 16:22, 31 January 2018 by Antonio.remedios (talk | contribs) (Antonio.remedios moved page Using Domain Users and Groups with SQL Repository to Using Domain Users and Groups with the SQL Repository without leaving a redirect)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

In order to use users and groups from your Domain with your SQL Repository, run the Configure XLCubed Web Edition application, then select the Sql Repository tab. By default, the Domain box will automatically be populated with the name of the local Domain, but it supports several formats:

Domain name
e.g. example.com
Load all the users and groups in the given domain
Localhost
Load all the users and groups from the host machine
A semi-colon delimited list of LDAP queries
e.g. LDAP://OU=Development,DC=somecom,DC=com; LDAP://OU=Consultants,DC=somecom,DC=com
Allows you to load users and groups from the domain, but limit the import to the given Organisation Units, etc.
A semi-colon delimited list of global catalog queries
e.g. GC://OU=Development,DC=somecom,DC=com; GC://OU=Consultants,DC=somecom,DC=com
If your domain supports it, this may be faster than the corresponding LDAP queries
Group filtering, for example
e.g. LDAP://DC=somecom,DC=com~(cn=group)
When using LDAP or GC queries, you may also filter the groups returned by using this form, where group can be a full group name or a wildcard (e.g. Sales*)

Automatically keeping the Domain information up to date

Once this has been configured, the XLCubed Scheduling Service can be used to keep the Domain information up to date on a regular basis. To set this:

  1. Run the Configure XLCubed Web Edition application
  2. Select the Scheduling tab
  3. Select the Schedule domain update box, and enter how frequently you would like to update the Domain information
  4. The update will occur at midnight, server time

Note that the XLCubed Scheduling Service must be set up correctly in order for this to succeed.

Manually running the Domain import process

From XLCubed v8.1.39, the Scheduling Service domain import process can be triggered manually by passing an extra command line parameter:

C:\inetpub\wwwroot\XLCubedWeb\Scheduler\XLCubed.Scheduling.Service.exe /UPDATEDOMAIN

This allows it to be called manually or via an automated process, for example Task Scheduler. The user running the process must be a member of the XLCUBED_ADMIN role.

Viewing the Domain import logs

In order to see the progress of an individual Domain import, or whether errors occurred on a previous occasion, run the Configure XLCubed Web Edition application, then select the Sql Repository tab. Click on the Administration button, then select the Admin > Logs > Active Directory menu.

See Also