How to list all of the restrictions configured in your Team Calendars
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
Server* 製品のサポートは 2024 年 2 月 15 日をもって終了します。Server 製品を利用している場合は、Atlassian Server のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
目的
If you are an administrator of Confluence and you'd like to check what are the restrictions applied to all of the Calendars in your Confluence instance, you may then use the following query.
ソリューション
To list users that have restrictions applied to your available Calendars:
The following query was tested on PostgreSQL.
SELECT tc."ID" AS "Calendar ID", "tc"."NAME" AS "Calendar Name", "tcp"."TYPE" AS "Restrictions Type", "um"."username" AS "Username" FROM "AO_950DC3_TC_SUBCALS_PRIV_USR" tcp
LEFT JOIN "user_mapping" um ON um."user_key" = tcp."USER_KEY"
LEFT JOIN "AO_950DC3_TC_SUBCALS" tc ON tc."ID" = tcp."SUB_CALENDAR_ID";
SELECT TC.ID as CALENDAR_ID , TC.NAME as calendar_name , TCP.`TYPE` as resctrictions_type, UM.username as username
FROM AO_950DC3_TC_SUBCALS_PRIV_USR TCP
LEFT JOIN user_mapping UM ON UM.user_key = TCP.USER_KEY
LEFT JOIN AO_950DC3_TC_SUBCALS TC ON TC.ID = TCP.SUB_CALENDAR_ID;
To list groups that have restrictions applied to your available Calendars.
SELECT tc."ID" AS "Calendar ID", "tc"."NAME" AS "Calendar Name",
"tcp"."TYPE" AS "Restrictions Type", tcp."GROUP_NAME"
FROM "AO_950DC3_TC_SUBCALS_PRIV_GRP" tcp
LEFT JOIN "AO_950DC3_TC_SUBCALS" tc ON tc."ID" = tcp."SUB_CALENDAR_ID";
SELECT TC.ID as CALENDAR_ID , TC.NAME as calendar_name , TCP.`TYPE` as resctrictions_type, TCP.GROUP_NAME as GROUP_NAME
FROM AO_950DC3_TC_SUBCALS_PRIV_GRP TCP
LEFT JOIN AO_950DC3_TC_SUBCALS TC ON TC.ID = TCP.SUB_CALENDAR_ID;