How to report on oldest pages in Confluence space?

John Straffin

Is there any way to create a report that displays the oldest pages in a space?

We'd like to make sure all of the content in our site is updated or confirmed as valid on a regular basis, and we figure that the best way to do that would be to work from a list of the oldest pages in our space. There's a "Recently Updated" page under Browse Space ... is there a way to get the opposite?

Bob Swift

Using the SQL Plugin for Confluence

{sql-query:datasource=confluenceDS|output=wiki}

select
    lastmoddate as "Last changed",
    '[' || (select spacename from spaces where spaces.spaceid = content.spaceid) || ':' || title || ']' as "Page"
  from content 
  where prevver is null and contenttype = 'PAGE' 
  order by lastmoddate 
  limit 100

{sql-query}