Active notification report

I'd like to be able to on a schedule run a report that just lists all the machines that currently have an active "alert" status and what that alert is. Just something easy to review each morning and see if there are any issues that weren't addressed the previous day. I know this can be viewed on the dashboard but pushing this to me as a report is more useful. So this would just be a report added to the report section that I could define a scope and run.