LDAP config info

Question

Where is LDAP Config Information saved in JIRA?

Thanks!

Mikael Sandberg · Answer

SELECT [directory_id]
 ,[attribute_name]
 ,[attribute_value]
 FROM [cwd_directory_attribute]

This is for MSSQL, dependent on what directory you want the information for you need to look in the cwd_directory first to figure out the directory id first. You could then run something like this to only see the attributes for the specified directory:

SELECT [directory_id]
 ,[attribute_name]
 ,[attribute_value]
 FROM [cwd_directory_attribute]
 WHERE [directory_id] = 1

Note that these queries are not complete, the FROM statement is missing the database and schema, those are dependent on your environment.

Harish Tuccapuram · Answer

Thanks @Mikael Sandberg by chance do you know the query for that, i am poor at writing the SQL queries.

Thanks!

Mikael Sandberg · Answer

It's stored in the database in the cwd_directory_attribute table.