SV: [msmom] SQL query to get alert information

[Henrik Andersen]

Hi, First af all - for direct queries allways use the defined views in the opsmgr database. It gives you and SCOM the Best performance. Secondly, what do you mean by receipients? Mayby try This google search "Holman useful SQL" It Will lead you to kevin Holmans very useful Collection of SCOM 2007 quries. Yes, I know it sats 2007 but it should give you a clue how to query the SCOM database. Regards Henrik Sendt fra min Windows Phone Fra: Rajeev Vithalani Sendt: ‎27-‎03-‎2014 00:13 Til: msmom@lists.myitforum.com Emne: [msmom] SQL query to get alert information 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