1 Reply Latest reply on Dec 17, 2013 12:09 PM by allanseyberth

    Is there a report in Solarwinds that will show who is getting alerts?

    scotthill

      Not sure if this is the right place, but I would like to be able to run a report that shows who is supposed to get alerts. Is there a way to track that or is it a manual process? Trying to pin down some recent changes in the environment to make sure that users get the alerts they need.

       

      Orion Platform 2013.1.0, SAM 5.5.0, NPM 10.5, IVIM 1.7.0

        • Re: Is there a report in Solarwinds that will show who is getting alerts?
          allanseyberth

          Do you mean who is configured as the email recipient of your existing alerts?  If so, this might get what you need:

           

          SELECT

             Actiondefinitions.target,

             AlertDefinitions.AlertDefID,

             AlertDefinitions.alertname

           

          FROM

             Actiondefinitions

           

          INNER JOIN

             Alertdefinitions ON AlertDefinitions.AlertDefID =  Actiondefinitions.AlertDefID

           

          WHERE

              Actiondefinitions.Actiontype like 'EMail'

           

          ORDER BY

              AlertDefinitions.alertname

          1 of 1 people found this helpful