SQL to locate pages created from Confluence templates

[Kathryn Reddie]

I am trying to find what Confluence pages were created using templates in the database.

I have located the pagetemplates table, but I'm not sure if I can use that data to find what was created using the specific template.  Can someone please help me find what table and attribute combination I could use to track them down?

I am expecting that some of the templates used to create the pages have been deleted.

Thanks in advance.

Kathryn.

[Nic Brough -Adaptavist- · Accepted solution]

The template used is not stored by Confluence.

[Kathryn Reddie]

Thanks Nic, much appreciated.