How to get the app usage details for Space tree for Confluence

This article helps you to get the list of pages where the Space Tree macros are added within your confluence instance that is hosted on the Server or Datacenter.

Instructions

Use the below SQL query in the database to get the list of pages that use the Space Tree macros:

1. Execute the below query to identify the list of pages where the spacetree macro is used:
   
   

   SELECT * FROM bodycontent bc JOIN CONTENT c ON bc.contentid = c.contentid WHERE c.prevver IS NULL AND bc.body like '%ac:structured-macro ac:name="spacetree%'

   
   The output is displayed as follows:
   
   

   Open

   

   
   
   

2. Execute the below query to see the results only for the column named title:
   
   

   SELECT title FROM bodycontent bc JOIN CONTENT c ON bc.contentid = c.contentid WHERE c.prevver IS NULL AND bc.body like '%ac:structured-macro ac:name="spacetree%'

   
   The output is displayed as follows:
   
   

   Open