How to identify ICS Calendar files in your database
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
Summary
The SQL database for Confluence will contain a number of AO tables. The purpose of this article is to document the AO tables which store ICS Calendar files.
You must have the ability to query your Confluence database to make use of this information.
Solution
ICS files will be merged into the following AO tables depending on the data inside the file:
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_JIRA_REMI_EVENTS
AO_950DC3_TC_REMINDER_SETTINGS
AO_950DC3_TC_REMINDER_USERS
AO_950DC3_TC_SUBCALS
AO_950DC3_TC_SUBCALS_IN_SPACE
AO_950DC3_TC_SUBCALS_PRIV_GRP
AO_950DC3_TC_SUBCALS_PRIV_USR
AO_950DC3_TC_SUBCALS_PROPS
Was this helpful?