How to get a list of newly added users with their email.
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Sometimes for reporting purposes, you may need to know what were the recently created users in Confluence.
For this, you can use the example provided below to extract that information from Confluence Database.
This document is provided as-is, what means that Atlassian Support won't provide assistance on modifying this example to fit your use case.
See Atlassian Support Offerings for additional information.
Environment
7.x, 8.x
Solution
In the example below the query will return the users that were created in the last 24 hours, their email addresses, and the creation time. You will require access to run queries on the Confluence database to extract these values.
It's possible to change the interval to extract different time intervals.
Postgres:
select distinct user_name,email_address,created_date from cwd_user where created_date > current_timestamp - interval '1 day'; SQL SERVER:
SELECT DISTINCT user_name, email_address, created_date
FROM cwd_user
WHERE created_date > DATEADD(day, -1, GETDATE());