Running a SQL Report on Confluence

Question

Greetings

I want to create a button on a page to run a query across all spaces and report all orphaned pages. Basically click the button and get a list of pages.

I found the SQL to do this in the knowledge base but I don't know how to put the SQL behind a button (or indeed if this is possible).

Thanks

Nigel.

Johan Soetens _Dumblefy_ · Accepted Answer

Hi Nigel,

there's no access to the database in Atlassian Cloud

Running SQL for your on-premise instances will need to be done directly to the database (the IDE/tooling depends a bit on type, for example SQL Developer).