Can you run a report to find see all of the pages that have not been updated for one year?

[Dean Kaflowitz]

This question is in reference to Atlassian Documentation: Status Report - Example of Page Properties Report MacroCan you run a report to find see all of the pages that have not been updated for one year?  The reason I ask is that this would simplify ISO 27001 auditing.

[Ash · Accepted solution]

please refer this answer

https://answers.atlassian.com/questions/218770.

[Dean Kaflowitz]

Thank you.  That actually answers the question perfectly.  Now I have to find out if we have the plugin.

[Paul Stallworth]

Is there any restriction to how you gather the data?  You could do it with SQL, something like 

select TITLE,CONTENTID,PAGEID from CONTENT where CONTENTTYPE = 'PAGE' AND DATEDIFF(year,LASTMODDATE,GetDate()) >= 1 AND PREVVER IS NULL; 

One thing to keep in mind is if you don't check for PREVVER IS NULL, then it will show a record for page histories that are older than a year.