Reset acknowledgments periodically

Hi, I am using a recent version of Icinga2 and Icinga2web. We recently found a gap in our monitoring processes where the operations guy sends an email and acknowledges an alert when it comes it. Unfortunately there is no follow up from there…

Despite pulling a list of all acknowledgments older than 7 days and notifying someone higher up the food chain, I would like to remove acknowledgements of alerts that are older than 7 days.
It must be a simple SQL query, I guess. What is the best way to achieve this?

Many thanks in advance

When setting ACK use “Use expire time” and set it to 7 days or any reasonable period.
We are using it. OPS team should get used to it though.