"Last Expired Date" of an answer for report
I'm trying to create a report for distribution of all expired answers, and the date they expired (to serve as a sort of 'ahem' to content owners), but the only column I see in the answers table dealing with expiration is the 'answers.expires' column, which for expired answers is set to null by the agedatabase.
I'm assuming there must be a way of including this data (the date the answer most recently was set to expired). It's in the audit log; I just can't figure out how to get it into the report. Another option would be to have the Expires On field *not* be nulled out when an article expires, then use the column I mentioned in the last paragraph -- I assume with a rule somehow -- but I feel like getting that other piece of data would be cleaner here.