cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 12

List Advanced Alerts

Is there a way to run a report that would list all advanced alerts that are configured. Something that would be readable by an administrator

0 Kudos
4 Replies

And Actually if they are an administrator there is the Manage Advanced Alerts on the Web Console under settings.

0 Kudos


The advanced alerts page on the web console should work for me. I am trying to change the number of entries displayed on that page and I can not find anywere that I can change that. I would like to have it display all my entries on 1 page . I think you would normaly do that under manage views but I dont see that page as an option to edit

0 Kudos

Create a report in report writer

SELECT TOP 1000 AlertName, Enabled, AlertDescription,TriggerSubjectTemplate, TriggerMessageTemplate, ResetSubjectTemplate, ResetMessageTemplate, LogMessage, NotifyEnabled FROM [dbo].[Alerts]

0 Kudos

AI needed the same information and created this report.

select
  ad.AlertDefID,
  ad.AlertName,
  ad.TriggerQuery
from AlertDefinitions ad
where
    Enabled = 1 -- True

order by
  ad.AlertName

Message was edited by: Marlene Underwood I think this gives you the Advanced Alerts.  Based on a quick test, I think the post above is the Basic Alerts.

0 Kudos