I would like to get a enabled alert report that shows the following Alert Names, Alert Description, Property to Monitor and Type.
It would look like what you would see when looking at the Manage Alerts web page.
I can do you one for everything but the type.
SELECT Name, Description, Enabled, ObjectTypeFROM Orion.AlertDefinitionsWHERE Enabled = 'True'
Add to a new report > custom table and change the dropdown to 'Advanced DB Query' and then paste in the above code. Then add all the fields in the resource section and drag/drop to your desired position.
@snorfolk, same thing as @stuartd mentioned in terms of creating the report, but the below query will get you all the data you asked for and format it similarly to what you see on that page.
SELECT AC.Name, AC.Description, AC.Enabled, AC.ObjectType, CASE WHEN AC.Canned = True THEN 'Out-of-the-box' Else 'User-Defined' END AS [Type]FROM Orion.AlertConfigurations ACWHERE AC.Enabled ='TRUE'
Thank you both for your replies, I will use the latter suggestion. Thank you
The script works that you, Thank you again.
But there is one more thing I would like to see. How can it report the following actions:
alert action(s) type
show email address that have chosen to receive the alerts
show where notifications that have been sent
