Problem Definition

It would be beneficial to add a macro on a parent page that can provide the last date, time, and the username the parent page along with its child pages was modified. This way the administrator can track pages that have been created but was not recently updated or referenced. This is useful for organizations with large deployment to clean up their instances and keep them up-to-date.

Suggested Solution

Add a macro on the parent page that will provide the last updated date/time and username for that page and its child pages.

Workaround

Using a database query, we can list all versions and modified dates of each page within a space:

select s.spacename, c.title, c.lastmoddate
from content c
join spaces s on s.spaceid = c.spaceid
where contenttype = 'PAGE'
and prevver is null
and spacename = ‘<SPACENAME>';

• The <SPACENAME> must be replaced with the particular Space name in concern.
• If you want the information to be reported on a page, you can do so using a third-party plugin Bob Swift's SQL for Confluence.