SCOM: how to create a report for all closed alerts.

 

external source with good samples

https://blogs.technet.com/b/kevinholman/archive/2008/07/21/auditing-on-alerts-from-the-data-warehouse.aspx

https://www.systemcentercentral.com/PackCatalog/PackCatalogDetails/tabid/145/IndexId/69990/Default.aspx

https://blogs.technet.com/b/jimmyharper/archive/2010/04/23/sample-queries-and-reports-from-my-mms-session.aspx