Is it possible to export the "Summary of Alert configuration" page? I'm guessing a SQL query may do it, I just do not know where all the info is stored.
There is an out-of-the-box Report entitled "All Configured Alerts" that contains virtually all information contained in the "Summary of Alert configuration" view.
I was hoping for the trigger action and reset action to be included.
I am looking for the same report. Did you already find it fcpsolaradmin?
no luck. I was going to ask our sql guy to try to make something for me. If he has luck I will post solution
Try this:
select ac.Name as 'Alert Name' ,ac.AlertMessage as 'Alert Message' ,ac.[Description] as 'Alert Description' ,cast((select replace(replace(ac.[Trigger], '<', '<'),'>','>')) as xml) as 'Trigger XML' ,cast((select replace(replace(ac.[Reset], '<', '<'),'>','>')) as xml) as 'Reset XML' ,a.title as 'ActionTitle' ,ap.emailto as 'Email To:' ,ap.emailcc as 'Email CC:' ,ap.emailbcc as 'Email BCC:' ,ap.emailfrom as 'Email From:' ,ap.sender as 'Email Sender Name' ,ap.[subject] as'Email Subject' ,ap.emailmessage as 'Email Message' ,ap.executionifaknowledge as 'Execute if Acknowledged?' ,ap.executionrepeattimespan as 'Minutes Between Repeat'from alertconfigurations acjoin actionsassignments aa on aa.parentid = ac.alertidjoin actions a on a.actionid = aa.actionidjoin( select actionid ,max(case when PropertyName = 'EmailBCC' Then PropertyValue End) 'EmailBCC' ,max(case when PropertyName = 'EmailCC' Then PropertyValue End) 'EmailCC' ,max(case when PropertyName = 'EmailFrom' Then PropertyValue End) 'EmailFrom' ,max(case when PropertyName = 'EmailMessage' Then PropertyValue End) 'EmailMessage' ,max(case when PropertyName = 'EmailTo' Then PropertyValue End) 'EmailTo' ,max(case when PropertyName = 'executionIfAknowledge' Then PropertyValue End) 'executionIfAknowledge' ,max(case when PropertyName = 'executionRepeatTimeSpan' Then PropertyValue End) 'executionRepeatTimeSpan' ,max(case when PropertyName = 'Sender' Then PropertyValue End) 'Sender' ,max(case when PropertyName = 'SmtpServerID' Then PropertyValue End) 'SmtpServerID' ,max(case when PropertyName = 'Subject' Then PropertyValue End) 'Subject' from actionsproperties group by actionid)ap on ap.actionid = aa.actionidwhere ac.[enabled] = 1order by ac.name, a.title desc
Obviously you can trim this down if needed, but it's got about every thing you could want for each alert. (Also, omit line 37 if you want to see all alerts and not just those that are enabled)
Hope it helps!
-ZackM
Loop1 Systems: SolarWinds Training and Professional Services
Hi ZackM,
That's very nice however the Trigger XML and Reset XML column are really not usefull as is.
Is there a way to have some formatting of these data in order to be able to read these data ?
There is very nice Summary page at the end of each Alert configuration. Is it possible to have a kind of report which display all the summery page of the Enabled alert ?
Cheers
