List users within the CONFLUENCE Internal Directory

Roja Gurram_ey6522

Hi Nic Brough _Adaptavist_,

 

How do we get the list of Internal users on Confluence Server 6.6.6 ?   

We have configured FOUR user directories in CONFLUENCE. THREE is linked to our Active Directory LDAP and the other  is the Confluence Internal Directory. 

Do you know how to provide this pls?

Joshua Sneed Contegix

Hi Roja,

Taking a look at How to delete all internal Confluence users except the local administrator offers a sub-query in SQL that might help find what you are looking for after a bit of pruning. It goes something like the following for Postgres/MySQL:

SELECT u.id FROM cwd_user u
JOIN cwd_directory d ON u.directory_id = d.id
WHERE d.lower_directory_name = 'confluence internal directory'

Please do not run the Delete queries unless you want to ruin you day. The trailing semicolon is left out on purpose. Cheers!