Purpose

Below are the queries that are needed to find the quantity and names of calendar created for Team Calendars for Confluence 4.2 or higher

Solution

• To find the names of all the calendars in Confluence:

  select NAME  from ao_950dc3_tc_subcals where PARENT_ID is NULL and SUBSCRIPTION_ID is NULL;

• To count the number of calendars in the Confluence instance:

  select count(*)  from ao_950dc3_tc_subcals where PARENT_ID is NULL and SUBSCRIPTION_ID is NULL;