How can I tell which LDAP attribute is linked to the external_id field in Confluence cwd_user table?
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.
In the course of debugging LDAP issues, an admin may need to understand which LDAP attribute is tied to the external_id value in cwd_user table in Confluence.
First, find the required LDAP Directory ID:Find the effected LDAP Directory ID
SELECT * FROM cwd_directory
Next, use the Directory ID obtained from the previous step to run the following query"Find the LDAP attribute tied to external_id in database table cwd_user
SELECT * FROM cwd_directory_attribute WHERE directory_id = '<directory-id-here>' AND attribute_name LIKE '%ldap.external.id%'
The output for attribute_value is the LDAP attribute that is tied to the external_id value in cwd_user for the affected directory.
- The external_id, can also be located under Confluence Support Zip > auth-cfg > directoryConfigurationSummary.txt under correct directory name by locating attribute "ldap.external.id".
Was this helpful?Yes Provide feedback about this article