Get number of pages/contents modified daily on Confluence
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
1
2
3
4
5
6
7
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;1
2
3
4
5
6
7
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;Was this helpful?