Is there a way to extract page level data on confluence

[Computing Services]

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

[Thomas Schlegel]

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.

[Computing Services]

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?

[Nic Brough -Adaptavist-]

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