Why does the default Group confluence-users show a difference in Group Members and Users

[Nathan Watterson]

Under Administration > User Management > Groups

There is a Group called confluence-users.

On the details page for this default group it shows a count and a list of users.

Currently the count is: Group members 7

Meanwhile the list shows 5 users.

Why do these numbers not match?

How do I find the 2 phantom members?

[Jonathan Smith · Accepted solution]

@Nathan Watterson,

  Confluence-users comes from your internal directory. The internal directory probably has admin/service accounts you used during setup. 

You can identify the admin accounts though SQL:

SELECT *FROM [Confluence].[dbo].[cwd_user]
WHERE directory_id='1'

[Nathan Watterson]

@Jonathan Smith makes sense, I'm new to the platform, where would I run this query on a jira-cloud instance?

[Jonathan Smith]

If you are on cloud, you won't have access to the database.

Please contact Atlassian support and they should be able to confirm the accounts (and service accounts) for confluence-users.