How to get a list of users/contributors that created page/blog From database
Platform Notice: Data Center and Cloud By Request - This article was written for the Atlassian data center platform but may also be useful for Atlassian Cloud customers. If completing instructions in this article would help you, please contact Atlassian Support and mention it.
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
Purpose
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
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
select username from dbo.user_mapping where user_key in (select CREATOR from dbo.CONTENT where CONTENTTYPE !='USERINFO' AND CREATOR is NOT NULL);
Last modified on Dec 17, 2024
Powered by Confluence and Scroll Viewport.