How to list all of the restrictions configured in your Team Calendars
プラットフォームについて: サーバーと Data Center のみ。この記事は、サーバーおよび Data Center プラットフォームのアトラシアン製品にのみ適用されます。
目的
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";
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";
最終更新日 2022 年 4 月 19 日
Powered by Confluence and Scroll Viewport.