Find All Users With a Null Value for an Attribute in Okta Using the LDAP Interface
Mar 20, 2026
Administration
Okta Classic Engine
Okta Identity Engine
Overview
This article describes how to find all users with a null value for an attribute in Okta using the Lightweight Directory Access Protocol (LDAP) Interface.
Applies To
- LDAP Interface
Solution
-
Connect to the Okta LDAP Interface using an LDAP client, such as Softerra LDAP Browser, with the LDAP Interface connection settings.
- Perform a directory search within the LDAP client, applying the desired LDAP filter to narrow the search results as needed.
- Select the list of attributes to export in the search results (for example, employeeNumber or mail).
- Export the search results in Excel or CSV format.
- Open the exported data and filter the report to identify users with blank values for the desired attributes.
