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:

(warning) 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.