How to get a list of users/contributors that created page/blog From database
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 Feb 26, 2016
Powered by Confluence and Scroll Viewport.