Crowd logging

Question

We see the detail when "adding/modifying directory" in Crowd application. However we don't have information that which table and column should we check in Postgres database.

Could you please provide sql query for this entry.

Thank you.

Fabio Racobaldo _Catworkx_ · Answer

Hi @Rehan ,

there are two different tables cwd_directory and cwd_directory_attribute can help you

select *
from cwd_directory cd
inner join cwd_directory_attribute cda on (cd.id=cda.directory_id);

Hope this helps,

Fabio