How to find the Creator of a Calendar in Team Calendars for Confluence

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

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. 

ユースケース

Team Calendars for Confluence does not show the creator of calendar. This information might be useful for the Confluence Administrator.

ソリューション

  • To find the creator of a calendar in the Team Calendars 4.1 and older, you can use the query below:
    • After Team Calendars for Confluence 4.2 Release the tables used to store the data moved from BANDANA into their own AO tables.
    • Since AO tables are generated on the side the numbers vary from instance to instance.
    • Team Calendars for Confluence tables follow a syntax of AO_$NUMBERS_TC_TABLENAME
      1. Run the following query and look for the {{AO_$NUMBERS_TC_TABLENAME}} as this holds the data for your Calendar owner.
    SHOW TABLES;
    	 
    	EXAMPLE OUTPUT:
    	 
    	AO_950DC3_TC_CUSTOM_EV_TYPES
    	AO_950DC3_TC_DISABLE_EV_TYPES
    	AO_950DC3_TC_EVENTS  
    	AO_950DC3_TC_EVENTS_EXCL
    	AO_950DC3_TC_EVENTS_INVITEES
    	AO_950DC3_TC_SUBCALS
    	AO_950DC3_TC_SUBCALS_PRIV_GRP
    	AO_950DC3_TC_SUBCALS_PRIV_USR
    	AO_950DC3_TC_SUBCALS_PROPS
    	AO_A0B856_WEB_HOOK_LISTENER_AO
      1. Team Calendars for Confluence stores its ownership information in the in the TC_SUBCALS Table of the AO’s generated in your Database. You Will run a the query:  SELECT * FROM AO_$variables_TC_SUBCALS;
    mysql> SELECT * FROM AO_950DC3_TC_SUBCALS;
    
    	EXAMPLE OUTPUT:
    
    	mysql> SELECT * FROM AO_950DC3_TC_SUBCALS;
    	+-----------------------+---------------+----------------------------------+-------------+--------------------------------------+-------------------+--------------------------------------+-----------+-------------------------------------------------------------------------------------------------+-----------------+-----------------+----------------------------+
    	| COLOUR                | CREATED       | CREATOR                          | DESCRIPTION | ID                                   | NAME              | PARENT_ID                            | SPACE_KEY | STORE_KEY                                                                                       | SUBSCRIPTION_ID | TIME_ZONE_ID    | USING_CUSTOM_EVENT_TYPE_ID |
    	+-----------------------+---------------+----------------------------------+-------------+--------------------------------------+-------------------+--------------------------------------+-----------+-------------------------------------------------------------------------------------------------+-----------------+-----------------+----------------------------+
    	| subcalendar-turquoise | 1423589352739 | 402887814b748222014b7483f8e00001 |             | 4dab6156-b7bd-4259-a18a-a258d1fdcbef | another calendar  | NULL                                 | NULL      | com.atlassian.confluence.extra.calendar3.calendarstore.generic.GenericSubCalendarDataStore      | NULL            | America/Chicago | NULL                       |
    	| subcalendar-blue      | 1423589084171 | 402887814b748222014b7483f8e00001 |             | 5d6510b1-fcc2-489b-8e7f-a9938a1d2d33 | Tins New Calendar | ac8c70b7-88e7-49f0-a785-ec13b7528119 | NULL      | com.atlassian.confluence.extra.calendar3.calendarstore.generic.GenericLocalSubCalendarDataStore | NULL            | America/Chicago | NULL                       |
    	| subcalendar-bronze    | 1423589076609 | 402887814b748222014b7483f8e00001 |             | ac8c70b7-88e7-49f0-a785-ec13b7528119 | Tins New Calendar | NULL                                 | NULL      | com.atlassian.confluence.extra.calendar3.calendarstore.generic.GenericSubCalendarDataStore      | NULL            | America/Chicago | NULL                       |
    	+-----------------------+---------------+----------------------------------+-------------+--------------------------------------+-------------------+--------------------------------------+-----------+-------------------------------------------------------------------------------------------------+-----------------+-----------------+----------------------------+
    	3 rows in set (0.00 sec)
      1. From this select statement we now have the variable for Creator. In this test you will see that my value for creator is 402887814b748222014b7483f8e00001
      2. Now that you have this variable you will be able to use the following query to find the owner. You will run the following query: SELECT * FROM user_mapping WHERE user_key LIKE ‘$CREATOR_From_Original_Query’;
    SELECT * FROM user_mapping WHERE user_key LIKE '402887814b748222014b7483f8e00001’;
    	+----------------------------------+----------+----------------+
    	| user_key                         | username | lower_username |
    	+----------------------------------+----------+----------------+
    	| 402887814b748222014b7483f8e00001 | admin    | admin          |
    	+----------------------------------+----------+----------------+
    	1 row in set (0.00 sec)
      1. To find the creator of a calendar in the Team Calendars 4.1 and earlier, you can use the query below:
      2. Run the following query below in you database. 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>%';
      1. Now Run the next query. Replace the <BANDANACONTEXT> with the previous query result
    select BANDANAVALUE from  BANDANA where BANDANACONTEXT = '<BANDANACONTEXT>';
      1. The query result 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>  
    	 |
      1. From the result, you can see the creator name, in this case it is 'admin':
    creator&quot;:&quot;admin&quot;
  • We have a feature request to track this:  TEAMCAL-144 - Getting issue details... STATUS  and hope to implement it in the product durectly. Watch that isssue to stay updated of when it is.

最終更新日: 2016 年 2 月 26 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.