Administrator Guide
188 | Preparing W-ClearPass for LDAP and SQLAuthenticationSources Dell Networking W-ClearPass Deployment Guide
Defining a Filter Query
The Configure Filter page allows you to define a filter query and the related attributes to be fetched from the
SQL DB store.
To define a filter query:
1. Navigate to Configuration > Authentication > Sources.
The Authentication Sources page opens.
a. If you're defining a new filter for an existing authentication source, click the name of the authentication
source, then select the Attributes tab.
b. If you're defining a new filter query for a newly configured authentication source, follow the steps
described in the previous section.
2. From the Attributes page, click Add More Filters.
The Configure Filter page opens.
Figure 154 Configure Filter Page: Generic SQL Authentication Source
3. Enter the information for each of the required parameters as described in Table 38.
Table 38: Configure Filter Page Parameters for Generic SQL Database
Parameter Action/Description
Filter Name Enter the name of the new filter.
Filter Query
Specify an SQL query to fetch the attributes from the user or device record in the
database.
Name Specify the name of the attribute.
Alias Name
Specify the alias name for the attribute. By default, this is the same value as the
attribute name.