How to get the Creator of a Calendar Event
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
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.
1
2
3
4
5
6
7
8
9
10
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>%';Was this helpful?