[otrs] Summary of ticket states

Hi, I want to generate a daily summary on the states of all open tickets in the system, which are beyond a certain time (escalated) and send this via mail to certain people (e.g. the queue administrators). Has anyone a solution ? Thanks Clemens