How to find the Creator of a Calendar in Team Calendars 4.1 and earlier
This guide is for informational purposes and is not eligible for support from Atlassian. If you have any questions about the information on this page, please reach out to our community at Atlassian Answers for help.
Use Case
Team Calendars for Confluence does not show the creator of calendar. This information might be useful for the Confluence Administrator.
For Team Calendars 4.2 and later, please check the KB How to get the Subscribers and Creator of a Calendar
Resolution
To find the creator of a calendar in the Team Calendars 4.1 and earlier, you can use the queries below:
Replace the <calendar_name> with the name of the calendar that you wish to find its creator.
select BANDANACONTEXT from BANDANA where BANDANAVALUE like '%X-WR-CALNAME:<calendar_name>%';
Now Run the next query. Replace the <BANDANACONTEXT> with the previous query result
select BANDANAVALUE from BANDANA where BANDANACONTEXT = '<BANDANACONTEXT>';
The output of this query should be similar to the one below:
| <string>{"id":"1c0ecd7a-0cf8-4db2-a3ec-11706f28ddfe","color":"subcalendar-turquoise","description":"ert","name":"trte","spaceKey":"","creator":"admin","timeZoneId":"Asia/Calcutta"}</string> | | <string>{"id":"6dc2caf6-5261-4de2-a3e7-eff19ffbebba","color":"subcalendar-blue2","description":"sdfsd","name":"dfsg","spaceKey":"","creator":"admin","timeZoneId":"Asia/Calcutta"}</string> |
From the result, you can see the creator name, in this case it is 'admin'