Disk voilation report

I need help in scheduling a report that sends us the information of all Disks that got voilated(all volumes that triggered alerts) for last 7 days. Is there any sql query to get this info.