List Of Confluence Internal Users

[Roja Gurram]

Hi Everyone,

How do we check  the list/total number of Internal users on Confluence Server 6.6.6  pls ?

Can someone urgently assist pls.

[Sachin]

Hello @Roja Gurram ,

As a confluence admin
- goto settings (cog) --> General Configuration -->  License Details --> Licensed Users
- if you like to know the list of all users : goto settings (cog) --> User Managemenet --> Show all users

Best,
Sachin.

[Roja Gurram]

Hi Sachin,

Am looking for the below pls. 

We have configured FOUR user directories in CONFLUENCE. THREE is linked to our Active Directory LDAP and the other  is the Confluence Internal Directory. We are doing migration from On prem server to AWS so, someone asking the total number of only "CONFLUENCE INTERNAL USERS".

Do you know how do we get the list/total number of Internal users on Confluence Server 6.6.6 ? 

[Sachin]

You can run some SQL queries on your database to get the users list - How to get a list of active users counting towards the Confluence license

[Roja Gurram]

Ok, Thank you Sachin.  Above article you have provided will not suits for this case.

Can you help/provide me out with the exact SQL query so, that i will ask DBA team to run the specific query  which it gives the count of only "Confluence Internal Users" not the AD users ?