Web Report for alert and receipient

Hi Team,

I got the following article for finding alert and recipient. Have someone created the report for it ....

Thanks

Prashant

Find more posts tagged with

Alert

recipient

report

Following query worked for me.

SELECT a.propertyvalue,c.alertmessage,c.name

FROM [dbo].[ActionsProperties] a join [dbo].[ActionsAssignments] b on a.actionid=b.actionid

join [dbo].[AlertConfigurations] c on b.parentid=c.alertid

Where a.propertyvalue like '%@xyz.com%'

and c.name like '%keyword_in_alert%'

SELECT TOP 1000 Name, Trigger, Reset, TriggerSubjectTemplate, TriggerMessageTemplate, ResetSubjectTemplate, ResetMessageTemplate

FROM Orion.Alerts