How to get the Creator of a Calendar Event
Problem
Currently, Confluence does not show who add/create event in a calendar from UI. You have to search DB to get the creator of a calendar event.
If you want to get the creator of a calendar , please check How to get the Subscribers and Creator of a Calendar
Resolution
Confluence Team Calendar stores events in "AO_950DC3_TC_EVENTS" table. You may run the following query to get the users who added event in a calendar. This is an example for Postgres DB.
SELECT "AO_950DC3_TC_EVENTS"."SUMMARY",
"AO_950DC3_TC_EVENTS"."DESCRIPTION",
"AO_950DC3_TC_SUBCALS"."NAME" AS "CALENDAR NAME" ,
user_mapping.username AS "USERNAME",
to_timestamp(("AO_950DC3_TC_EVENTS"."CREATED"/1000)) AS "CREATED"
FROM "AO_950DC3_TC_EVENTS" JOIN "AO_950DC3_TC_SUBCALS"
ON "AO_950DC3_TC_EVENTS"."SUB_CALENDAR_ID" = "AO_950DC3_TC_SUBCALS"."ID"
JOIN user_mapping user_mapping
ON user_mapping.user_key = "AO_950DC3_TC_EVENTS"."ORGANISER"
WHERE "SUMMARY" like '%<event>%';
Last modified on Aug 28, 2023
Powered by Confluence and Scroll Viewport.