Get number of pages/contents modified daily on Confluence
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
要約
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.
環境
Confluence 6.13.8+
ソリューション
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;
最終更新日 2021 年 7 月 20 日
Powered by Confluence and Scroll Viewport.