Get number of pages/contents modified daily on Confluence

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

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

Was this helpful?

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