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

    Alert - Ownership

    bvaughan1

      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
          d09h

          Does this work for you?

           

          https://support.solarwinds.com/Success_Center/Network_Performance_Monitor_(NPM)/Alert_not_working_after_alert_owner_account_is_disabled_

           

           

          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

          Overview

          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.

           

           

          Environment

          • 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

          Resolution

          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.
            Notes:
            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?