Hello, I'd like to have a report with all enabled alerts. I found a topic for basic alerts but cannot find one for advanced ones. The report should contain Alert name, triggering conditions and actions.
Thanks in advance.
You can setup a custom SQL report using the following SQL:
select AlertName, ObjectType, TriggerQuery, ActionType, Title from AlertDefinitions
inner join ActionDefinitions on ActionDefinitions.AlertDefID = AlertDefinitions.AlertDefID
where TriggerAction = 1
order by AlertName, SortOrder