How to get a list of users/contributors that created page/blog From database
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
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
To generate a list of user that had created any content in Confluence before
Solution
Run below's query in your database:
ℹ️ This sample query of Mysql
1
select username from user_mapping where user_key in (select creator from content where contenttype !="USERINFO" and creator is NOT NULL);ℹ️ This sample query of MSSQL
1
select username from dbo.user_mapping where user_key in (select CREATOR from dbo.CONTENT where CONTENTTYPE !='USERINFO' AND CREATOR is NOT NULL);Updated on April 8, 2025
Was this helpful?
Still need help?
The Atlassian Community is here for you.