List users within the CONFLUENCE Internal Directory

[Roja Gurram]

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

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!

[Roja Gurram]

Hi Joshua Sneed _ Contegix,

Thank you for providing the query. But , we are using MSSQL SERVER

[Joshua Sneed Contegix]

Hi Roja,
You're welcome and my condolences. I am not a DBA and will not provide a query for MSSQL as it would likely not work, break something, or cause any number of problems. Maybe the DBAs you mentioned on the other, duplicate posting can translate the query.
You may also want to consider using a plugin from the Marketplace. One possibility is using Atlassian's Rest API Browser to identify a private API endpoint where you are able to expand on directory ID. Cheers!