How to get a list of all user and group restrictions configured in your Team Calendars
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Purpose
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.
Solution
To list users that have restrictions applied to your available Calendars:
Postgres
1
2
3
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";MySQL
1
2
3
4
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:
Postgres
1
2
3
4
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";MySQL
1
2
3
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;Was this helpful?