How to get a list of users/contributors that created page/blog From database

Still need help?

The Atlassian Community is here for you.

Ask the community

Purpose

To generate a list of user that had created any content in Confluence before

Solution

 

Run below's query in your database:

(info) 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);

(info) 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

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.