find recently viewed or modified spaces and their content in Confluence
プラットフォームについて: Cloud と Data Center - この記事は クラウド プラットフォームとデータセンター プラットフォームの両方に等しく当てはまります。
Server* 製品のサポートは 2024 年 2 月 15 日に終了しました。Server 製品を実行している場合は、 アトラシアン Server サポート終了 のお知らせにアクセスして、移行オプションを確認してください。
*Fisheye および Crucible は除く
要約
As an admin, you may want to get a list of all spaces, with their creation date, the last modified date (of any content) and the last viewed date of a content in a space.
There currently isn't a way to export this information directly from the Confluence via the UI.
ソリューション
Recently viewed pages and blog posts are stored in the AORECENTLY_VIEWED table in Confluence's database:
MySQL
WITH Recently_Viewed AS (SELECT
SPACE_KEY, MAX(LAST_VIEW_DATE) as last_view_date
FROM AO_92296B_AORECENTLY_VIEWED
GROUP BY 1)
SELECT s.spacename, s.spacekey, s.creationdate as creation_date, MAX(c.lastmoddate) as last_updated_date,r.last_view_date
FROM CONTENT c
JOIN SPACES s ON s.spaceid=c.spaceid
LEFT JOIN AO_92296B_AORECENTLY_VIEWED r ON r.SPACE_KEY = s.spacekey
GROUP BY 1,2,3,5;PostgreSQL
WITH Recently_Viewed AS (SELECT
"SPACE_KEY", MAX("LAST_VIEW_DATE") as "last_view_date"
FROM "AO_92296B_AORECENTLY_VIEWED"
GROUP BY 1)
SELECT s.spacename, s.spacekey, s.creationdate as "creation_date", MAX(c.lastmoddate) as "last_updated_date",r."last_view_date"
FROM content c
JOIN spaces s ON s.spaceid=c.spaceid
LEFT JOIN Recently_Viewed r ON r."SPACE_KEY" = s.spacekey
GROUP BY 1,2,3,5;ORACLE
WITH Recently_Viewed AS (
SELECT
"SPACE_KEY",
MAX("LAST_VIEW_DATE") AS "Space_Last_View_Date"
FROM
AO_92296B_AORECENTLY_VIEWED
GROUP BY
"SPACE_KEY"
)
SELECT
s.spacename,
s.spacekey,
s.creationdate AS "Space_Creation_Date",
MAX(c.lastmoddate) AS "Space_Last_Updated_Date(Page_Created Or Page_Modified)",
r."Space_Last_View_Date"
FROM
content c
JOIN
spaces s ON s.spaceid = c.spaceid
LEFT JOIN
Recently_Viewed r ON r."SPACE_KEY" = s.spacekey
GROUP BY
s.spacename,
s.spacekey,
s.creationdate,
r."Space_Last_View_Date";
Note that this table by nature tracks recency and does not contain all historical data for page/space views. If you are looking to track overall page/space views, you will need to consult the Atlassian Marketplace for plugins that may extend this functionality in Confluence.
この内容はお役に立ちましたか?