LDAP config info

[Harish Tuccapuram]

Where is LDAP Config Information saved in JIRA?

Thanks!

[Mikael Sandberg]

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

[Harish Tuccapuram]

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

Thanks!

[Mikael Sandberg]

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.