Imported Active Directory users do not appear in All Users due to special character "_" used in User Blacklist setting
Imported Active Directory users do not appear in All Users due to special character "_" used in User Blacklist setting
Summary
This article describes how the special character "_" used in a User Blacklist definition may prevent some imported Active Directory users from being listed on the All Users page.
Symptoms
Even though the Active Directory import as well as the Recognition with the Update inventory for reconciliation complete successfully, some existing users in the imported Active Directory are not listed on the All Users page.
Cause
This is because some users may be ignored as per the User Blacklist settings. And since FlexNet Manager Suite uses the defined values in the WHERE clause of SQL query, use of special characters in SQL may cause unexpected behavior.
For example, "_" is the wildcard of single character in SQL. If "sa_%" is defined in a User Blacklist, while you may expect it to ignore user names starting with "sa_", it actually ignores user names starting with "sa".
Resolution
If a User Blacklist setting contains special characters of SQL, please escape them properly.
For example: "sa[_]%" ignores user names starting with "sa_".
