Via the Archiving Plugin
The Archiving Plugin is a great tool for managing outdated content.
Via SQL
This can be achieved by running the following SQL query on your Confluence database.
select * from content as c, spaces as s where c.spaceid = s.spaceid and s.spacename='INSERT SPACE NAME HERE' and c.LASTMODDATE < 'INSERT DATE HERE';