How to find out who is the Calendar creator

[Elena Oleksenko]

Hello, 

Please help to understand how I can find out who is creator of a Calendar in Confluence. 

I found this article https://confluence.atlassian.com/confkb/how-to-find-the-creator-of-a-calendar-in-team-calendars-for-confluence-389777998.html and tried the described method. 

I run the query

mysql> SELECT * FROM AO_950DC3_TC_SUBCALS WHERE NAME LIKE 'The Birthdays Calendar';

and I got the result with more than 1000 rows with the different user id's for the same calendar.

Like: 

subcalendar-blue: some user id
subcalendar-gray: another user id
subcalendar-purple2: one more user id
subcalendar-blue: the new id again

How to find out who is the real creator of the calendar? 

[Shannon S]

Elena,

Thank you for reaching out! It's nice to hear from you again.

1. You can confirm the example from the article is the same as in your database? You can confirm by running: 
   

   SHOW TABLES;
   

2. When you run JUST the following query, you still get 1,000s of results? 
   

   SELECT * FROM AO_#variables_TC_SUBCALS;

It does seem odd that you would get 1,000s of results, especially if you don't have that many calendars. It might be that we need to raise a support ticket so you can share a copy of your database with our support engineers, but let's see how far we can get on this before that needs to happen.

Regards,

Shannon

[Elena Oleksenko]

Hello Shannon, 
Thank you for the reply! I created a request to Atlassian support

[Shannon S]

Hi Elena,

Thank you for letting me know! I would recommend also linking this Community post on the ticket. That way, when the issue is resolved, you can let us know how that was done here. It can help users in the future should they run into the same issue.

Thanks again!

Shannon