/
How to get usage information of an app being used in space templates

How to get usage information of an app being used in space templates

Owned by Reshma Begum
Last updated: Sept 18, 2020 by Smita Nair

This article explains how to get the usage information about an app that is used in space templates.

Instructions

The PAGETEMPLATES table in the Confluence database maintains all the content inside the space specific templates.

  • Run the following SQL query in the Confluence database that fetches the list of pages that uses the required macro: 

    SELECT P.TEMPLATEID, P.TEMPLATENAME, P.CONTENT, P.SPACEID FROM PAGETEMPLATES P join SPACES S where CONTENT like '%ac:name="sql-query"%' AND P.SPACEID = S.SPACEID
    • In th