This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Flexera Community
- :
- FlexNet Manager
- :
- FlexNet Manager Knowledge Base
- :
- Imported Active Directory users do not appear in All Users due to special character "_" used in User...
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
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_".
No ratings