CODEWITHSUNDEEP
mysqlconfluenceconfluence-rest-api
Sadhan
Sadhan

Reputation: 15

How to get the list of users who have edit the pages in confluence?

I need to get the list of users who are just viewing the pages(all spaces/one space) but not editing the pages(all spaces/one space) in confluence and i want to get the list of users who are editing the pages.So,i logged into my servers mysql db and opened the database schema and have run the below query. 

SELECT distinct u.lower_user_name, l.successdate FROM cwd_user u LEFT JOIN logininfo l ON u.user_name = l.usernameJOIN cwd_membership m ON u.id = m.child_user_id JOIN cwd_group g ON m.parent_id = g.id JOIN SPACEPERMISSIONS sp ON g.group_name = sp.permgroupname WHERE permtype='USECONFLUENCE' order by u.lower_user_name;

This is giving the list of users which is more than the actual users in my confluence. But, my requirement is different and i could not find any related documents or queries from the below link "https://confluence.atlassian.com/disc/administration-tips/obtaining-confluence-instance-metrics". I am sure am running in correct schema and i cannot use any plugins for this.

Upvotes: 0

Views: 476

Answers (1)

Saleh Parsa
Saleh Parsa

Reputation: 1433

By default Confluence doesn't store content view statistic in Database and I believe if you just need to find the viewer, you have to use third party plugins (here).

Upvotes: 0

Related Questions