How to identify ICS Calendar files in your database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
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
Purpose
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