Import SQL Data | Suspend AD Users rule

Limit Scope to this Domain or OU

This setting defines the search query scope.

To improve query performance, limit the scope to specific OU.

SQL Instance

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.

SQL Database Name

Specify database name from selected SQL Instance.

SQL Table

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

SQL Credentials

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

Data Source Filter

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

Return These SQL Columns

Specify columns returned by the data source.

Where Clause

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

Returned Properties

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

Filter

Set the filtering conditions to only return objects or data that need to be processed by the rule.

Example: filter by Name column.

Data Source Anchor attribute

Select the column in the data source that will be used to find a matching user account in Active Directory and suspend a matching account.

The value of this column in the data source is compared to the Active Directory Anchor Attribute value in the Active Directory.

Active Directory Anchor attribute

Select the attribute in the Active Directory to compare the Data Source Anchor attribute when searching for a matching user account. 

Initialization Script

Initialization script

Usually, rules use query criteria to limit the query search scope. It improves the performance of the executed rule.

Due to PowerShell limitations, it is not possible to use calculated expressions in query criteria. That is the point where the initialization script can help. You can initialize a global variable in this setting and then use it in query criteria. 

Example: Update AD users, created in the last ten days.

1. Add this initialization script:

{$global:DatePeriod = (Get-Date).AddDays(-10)}

2. Use $DatePeriod variable in query criteria builder:

The rule has been introduced in the product.