How to get the Subscribers and Creator of a Calendar
Problem
The purpose of this document is to provide the steps to get a list of users subscribed to a specific calendar, or the creators of a calendar.
If you are interested in getting a list of the users watching a specific calendar, please check How to get the users Watching a Calendar
Solution
Subscribers
Run the following query to get a list of the subscribers of every Calendar in your Confluence site:
SELECT tc."NAME" AS "Calendar Name", um."username" AS "Subscriber"
FROM "AO_950DC3_TC_SUBCALS" tc
LEFT JOIN "user_mapping" um ON um."user_key" = tc."CREATOR"
WHERE "PARENT_ID" IS NULL AND "SUBSCRIPTION_ID" IS NOT NULL
ORDER BY 1,2
If you need to filter by Calendar name, just add a WHERE clause based on tc."NAME" column.
Creators
Run the following query to get the users who created every Calendar in your Confluence site:
SELECT tc."NAME" AS "Calendar Name", um."username" AS "Creator"
FROM "AO_950DC3_TC_SUBCALS" tc
LEFT JOIN "user_mapping" um ON um."user_key" = tc."CREATOR"
WHERE "PARENT_ID" IS NULL AND "SUBSCRIPTION_ID" IS NULL
ORDER BY 1,2
If you need to filter by Calendar name, just add a WHERE clause based on tc."NAME" column.
There is an open suggestion to implement a functionality to know who is the creator of a calendar in the UI: