This used to work when running 10.6, since the upgrade that imported the alerts to web based this no longer works. Does anyone have report setup that will give similar output?
select AlertName, ObjectType, Alertdescription,TriggerQuery, ActionType, Title from AlertDefinitions
inner join ActionDefinitions on ActionDefinitions.AlertDefID = AlertDefinitions.AlertDefID
where TriggerAction = 1 AND Enabled = 1 AND ActionDefinitions.ActionType = 'email'
order by AlertName, SortOrder