Confluence Active Directory Group

[AKASH BHARDWAJ]

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 · Accepted solution]

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

[AKASH BHARDWAJ]

Thank You Jing HWA,

I have got what i wanted.

[jing_hwa_cheok]

Glad I could help.

[AKASH BHARDWAJ]

I am working on Active Directory, now my question is that :

I have Active Directory configured with Confluence.

There are currently 85 Such groups and i want all 1000 Groups present in my Active Directory to be visible under Confluence.

Please let me know your thoughts on this.

Thanks,