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.
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
Summary
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.
Environment
Confluence 6.13.8+
Solution
Number of pages created per day
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;
Number of pages modified per day
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;
Last modified on Jul 20, 2021
Powered by Confluence and Scroll Viewport.