4 Replies Latest reply on May 31, 2018 5:08 PM by tonyreel

    Alert - Ownership


      How do you change the owner of an Alert? We have several alerts that were created by a user that no longer exists, Currently their account is inactive for fear of other issues since they were an Admin, and while the ALERTS show active they are not working. We need to change the owner from them to another account, how is this done?

        • Re: Alert - Ownership

          Does this work for you?





          HomeNetwork Performance Monitor (NPM)Alert not working after alert owner account is disabled
          Alert not working after alert owner account is disabled

          Updated March 11th, 2016


          Alerts owned by an account user that has been deleted/disabled have stopped working.


          The Alerting,Service.v2.log file located in C:\ProgramData\Solarwinds\Logs\Orion\ shows the following message:

          2017-08-23 09:04:48,105 [54] WARN  SolarWinds.Orion.Core.Alerting.Plugins.Conditions. Swql.ConditionEvaluatorSwql - Condition evaluation failed : User account is disabled.




          • Orion Core
            • 2015.x
            • 2016.x
            • 2017.1
          • NPM
            • 11.5.x
            • 12.0
            • 12.0.1
            • 12.1
          • SAM
            • 6.2.x
            • 6.3
            • 6.4


          This issue is resolved in NPM 12.2 or any module which ships with Orion Core 2017.1.3 or newer. If you're on an a release listed above the recommendation is to upgrade Orion to the latest release.


          Alternatively, there are workarounds below for these older releases:

          Reactivate the user account or change the ownership of the alerts:

          Warning: Changing the ownership may return different results due to various user limitations.

          1. Create a backup of the database.
          2. Click Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager.
          3. Click Add Default Server and expand down to your SolarWinds database.
          4. Double-click the Alert Configurations table.
          5. Delete the default query and replace with the following:
            1. If Old users are present:
              UPDATE AlertConfigurations
              SET CreatedBy = '{new user}'
              WHERE CreatedBy = '{old user}'
            2. If affected alerts have NULL:
              UPDATE AlertConfigurations
              SET CreatedBy = '{new user}'
              WHERE CreatedBy is NULL
          6. Click Execute Query.
            For a list of accounts, check the Accounts table.
            Pay attention to letter casing in account names.
          7. After updating the DB, restart Alerting Service V2
          1 of 1 people found this helpful
          • Re: Alert - Ownership
            van shoozen

            How did the workaround work for you?