ユースケース

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

ソリューション

To find the creator of a calendar in the Team Calendars 4.1 and earlier, you can use the queries below: 

1. 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>%';

2. Now Run the next query. Replace the <BANDANACONTEXT> with the previous query result

   select BANDANAVALUE from  BANDANA where BANDANACONTEXT = '<BANDANACONTEXT>';

3. The output of this query should be similar to the one below: 

   | 
   	<string>{&quot;id&quot;:&quot;1c0ecd7a-0cf8-4db2-a3ec-11706f28ddfe&quot;,&quot;color&quot;:&quot;subcalendar-turquoise&quot;,&quot;description&quot;:&quot;ert&quot;,&quot;name&quot;:&quot;trte&quot;,&quot;spaceKey&quot;:&quot;&quot;,&quot;creator&quot;:&quot;admin&quot;,&quot;timeZoneId&quot;:&quot;Asia/Calcutta&quot;}</string>
   	 |
   	| 
   	<string>{&quot;id&quot;:&quot;6dc2caf6-5261-4de2-a3e7-eff19ffbebba&quot;,&quot;color&quot;:&quot;subcalendar-blue2&quot;,&quot;description&quot;:&quot;sdfsd&quot;,&quot;name&quot;:&quot;dfsg&quot;,&quot;spaceKey&quot;:&quot;&quot;,&quot;creator&quot;:&quot;admin&quot;,&quot;timeZoneId&quot;:&quot;Asia/Calcutta&quot;}</string>  
   	 |

   
   From the result, you can see the creator name, in this case it is 'admin'