Loading
search-img
Title
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_".
Was this helpful?
Support Hub
Product
FlexNet Manager Suite
Deployment type
On-premises
Visibility
Guest
URL Name
imported-active-directory-users-do-not-appear-in-all-users-due-to-special-character-used-in-user-blacklist-setting

Related Articles

Create a case with Support
0/255
Upload Attachment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to cancel the case creation?

Are you sure you want to close this case

Get Hotline support
Products Region Phone Numbers
FlexNet Operations
FlexNet Embedded
FlexNet Publisher
FlexNet Connect
FlexNet Code Insight
InstallAnywhere
InstallShield 		North America  * +1 630-332-2513 (toll)
+1 877-279-2853 (toll-free in North America)
Europe  * +44 1925 944367 (toll)
+44 800 047 8642 (toll-free in Europe)
Japan  * +81 3-4540-5335 (select option 2)
Australia  * +61 3 9895 2177
+61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics)
Compliance Intelligence 		Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.
Book an Appointment
File Upload
Maximum file size allowed is 3 MB.
File type not supported.
Supported file types:
Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)
+1.800.374.4353
CONTACT US REVENERA.COM FLEXERA.com
© 2026 Flexera Software. All Rights Reserved.
Privacy policy Terms and conditions Flexera Community Contact Us
Loading
Imported Active Directory users do not appear in All Users due to special character "_" used in User Blacklist setting