Confluence Active Directory Group

AKASH BHARDWAJ2

Hi All Genius, out there. I am struggling to find all the groups which are there in Active Directory. My Active Directory is pointing to LDAP external Directory.

So My question is I need to look Which all groups are there that are there in Acitve Directory.

Can I list those and How??

Thanks,

Akash,

jing_hwa_cheok

Hi Akash,

You can run the query below in your Confluence database which will basicly list all the group associate to external user directory in your Confluence.

SELECT m.list_index, d.active, d.id as DirectoryID, d.directory_name, d.directory_type, g.id as GroupID, g.group_name FROM cwd_group g JOIN cwd_directory d ON g.directory_id = d.id JOIN cwd_app_dir_mapping m ON d.id=m.directory_id WHERE d.directory_type != 'INTERNAL' ORDER BY 2 DESC, 1 ASC;

Hope this helps!

Regards,
Jing Hwa