Is there a way to extract page level data on confluence

Question

Hi, I have been asked if we can get a report  that contains information about pages within a space. This includes the last modified date and their URLs and the page title. Is this possible?

I have managed to find how to find this information for Spaces, but couldn't find the URL.

(select SPACENAME, LASTMODDATE from SPACES;)

Thanks for your help,

L

Computing Services · Answer

Hi thanks for that, looks like an expensive plugin for something that we only want to do a one-off. maybe in the future but right now just trying to fulfill a request. Thank though. i'm really just looking for a query to send to the database. is that not possible?

Thomas Schlegel · Answer

Hi,

we build such reports with the app "Reporting for Confluence".

It's not so easy to understand, how this reporting framework works, but it is very very powerful.

Nic Brough -Adaptavist- · Answer

You'll find the REST API far easier to use than SQL.  Have a look at https://developer.atlassian.com/server/confluence/expansions-in-the-rest-api/ for example