MCMS - tracking expiry

I have just started working on a very large site, which will be edited by various depts around the business, a lot of the information that they input is subject to expiry - so I want to use the 'publish until' function in MCMS, but to be able to track it and send out reminders to the various teams to check their content. What would be the best way of generating a report to show which pages were coming up to their expiry date?

Thanks,
D