Hello, I'm trying to find out what all alerts were generated by SCOM that would include rule/monitor name, source, alert generation time, alert description, alert recipient information directly from SCOM 2012 OperationsManager DB. So far I'm able to get almost every information except to whom these alerts were sent. The query that I've identified are:
select top 100 * from [dbo].[Alert] al inner join [dbo].[AlertHistory] ah on al.AlertId = ah.AlertId inner join [dbo].[BaseManagedEntity] b on al.BaseManagedEntityId = b.BaseManagedEntityId Thanks Rajeev
