Get number of pages/contents modified daily on Confluence
Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.
Sometimes users want to get the count of pages created and pages modified per day in Confluence. With access to the database, you will be able to get this information by running some queries.
select count(CONTENTID) CREATED_PAGES, DATE(CREATIONDATE) CREATION_DATE from CONTENT where CONTENTTYPE='PAGE' and PREVVER is null and CREATIONDATE between '2010-01-01' and '2021-04-01' group by CREATION_DATE order by CREATION_DATE;
select count(DISTINCT(LOWERTITLE)) MODIFIED_PAGES, DATE(LASTMODDATE) MODIFIED_DATE from CONTENT where CONTENTTYPE='PAGE' and PREVVER is not null and LASTMODDATE between '2021-01-01' and '2021-04-01' group by MODIFIED_DATE order by MODIFIED_DATE;