2 Replies Latest reply on Nov 7, 2019 6:15 PM by mesverrum

    Report for existing alert configurations

    arunprasaad

      Hi,

       

      I need to configure a report that gets me the summary details [in the last summary page] of all the 'Alerts configured in solarwinds'

      Since i require the details of trigger conditions and trigger actions configured in each alert.

      Kindly help me in this regard.

       

      Thanks,

      Arun.

          • Re: Report for existing alert configurations
            mesverrum

            No answers because it can't be done in any user friendly way.  It's fairly easy to get a report that breaks down everything except the trigger and reset conditions.  Those are stored as xml in the database and I have yetto come across anyone who has any good tricks for parsing them back into something that is really human readable.

             

            If you run this as a SWQL query it will give you the data if want to take a crack at decoding it

            --Alert Configuration and Actions Report

            select 

            ac.name as  [Alert Name]

            ,ac.Description

            ,ac.Frequency

            ,CASE

            WHEN ac.Severity = 2 then 'Critical'

            WHEN ac.Severity = 3 then 'Serious'

            WHEN ac.Severity = 1 then 'Warning'

            WHEN ac.Severity = 0 then 'Informational'

            WHEN ac.Severity = 5 then 'Notice'

            END AS [Severity]

            ,ac.AlertMessage

            ,ac.trigger

            ,ac.reset

            ,aa.CategoryType

            ,a.actiontypeid

            ,ap.propertyname

            ,ap.propertyvalue

             

            from orion.actionsassignments aa

            join orion.alertconfigurations ac on aa.parentid=ac.alertid

            join orion.actions a on a.actionid=aa.actionid

            join orion.actionsproperties ap on ap.actionid=a.actionid

             

            where ac.enabled=1

             

            order by ac.Name, aa.Categorytype desc, a.ActionTypeID, ap.PropertyName