Submit a ticketCall us
Home > Success Center > Network 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.

Environment

  • Orion Core 2015.X 
  • NPM 11.5 and Higher

Resolution

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: 
    UPDATE AlertConfigurations
    SET CreatedBy = '{new user}'
    WHERE CreatedBy = '{old user}'
  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.

 

Last modified
15:56, 2 Jun 2017

Tags

Classifications

Public