This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

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

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

  • 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