Purpose

For purposes of auditing or organization, Confluence administrators may find it useful to see which pages are nested under a given parent page, and how many. This is helpful when examining a large space, to see which branch in the page tree contains the most pages.

Solution

1. Via the UI, by editing the page and grabbing the "pageId" value from the address bar

2. Via the database, by running:

   SELECT contentid FROM CONTENT WHERE prevver IS NULL AND title = 'Your Page Title';

3. Run a query below, depending on what you want to do:

   1. Getting a listing of all pages (pageId and title) under the parent

      SELECT c.contentid, c.title FROM CONFANCESTORS a JOIN CONTENT c ON a.descendentid = c.contentid WHERE a.ancestorid = '<parent_page_id>';

   2. Getting a total count of pages under the parent

      SELECT COUNT(*) FROM CONFANCESTORS WHERE ancestorid = '<parent_page_id>';

Related pages

• How to find the number of pages, blogposts, and attachments
• How to find pages in Confluence with a certain number of labels