Confluence で作成されたすべてのチーム カレンダー、それらの作成者、および作成日の一覧を作成する方法

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

This queries below will return 4 columns (creator, calendar_name, space and creation_date) for all calendars in the database. This data can be useful for reporting for all Team Calendars for Confluence, their creation dates, spaces they are in and creators for administrators.


Confluence 5.3+ のみ

SQL Server
SELECT um.lower_username as creator, tc.NAME as calendar_name, tc."SPACE_KEY" as Space, dateadd(second,cast(cast(tc.CREATED AS nvarchar(255)) AS bigint)/1000,'19700101 00:00:00:000') as creation_date
FROM AO_950DC3_TC_SUBCALS tc
JOIN user_mapping um ON um.user_key = tc.CREATOR
WHERE tc.PARENT_ID IS NULL
ORDER BY creator;
MySQL
SELECT um.lower_username as creator, tc.NAME as calendar_name, tc."SPACE_KEY" as Space, from_unixtime(round(tc.created/1000)) as creation_date
FROM AO_950DC3_TC_SUBCALS tc
JOIN user_mapping um ON um.user_key = tc.CREATOR
WHERE tc.PARENT_ID IS NULL
ORDER BY creator;
Postgres
SELECT
  um.lower_username as creator,
  tc."NAME" as calendar_name,
  tc."SPACE_KEY" as Space,
  to_timestamp(CAST(tc."CREATED" AS bigint) / 1000) as creation_date
FROM
  "AO_950DC3_TC_SUBCALS" tc
  JOIN user_mapping um ON um.user_key = tc."CREATOR"
WHERE
  tc."PARENT_ID" IS NULL
ORDER BY
  creator;
Oracle
SELECT um.lower_username as creator, tc.NAME as calendar_name, tc."SPACE_KEY" as Space, to_date('01.01.1970','dd.mm.yyyy') + to_number(tc.created)/1000/60/60/24 AS creation_date
FROM AO_950DC3_TC_SUBCALS tc
JOIN user_mapping um ON um.user_key = tc.CREATOR
WHERE tc.PARENT_ID IS NULL

ORDER BY creator; 



 


最終更新日 2024 年 5 月 16 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.