Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

Home > Success Center > Network Performance Monitor (NPM) > Reports are unable to work after Report Owner is disabled, removed, or now has limitation

Reports are unable to work after Report Owner is disabled, removed, or now has limitation

Created by James Fahey, last modified by MindTouch on Jun 23, 2016

Views: 19 Votes: 0 Revisions: 4


This article describes the issue when Reports are not working after Report Owner is disabled, removed, now has limitations, or has disable session time out enabled.


  • Orion Core version 2015.X
  • NPM version 11.5.X


This issue occurs when the original report owner is disabled, deleted/removed, was implemented limitation or the account has the disable session time out enabled.


  1. Reactivate the user account or change the ownership of the report:

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

  2. Create a backup of the database.
  3. Click Start > All Programs > SolarWinds Orion > Advanced Features > Database Manager.
  4. Click Add Default Server and expand down to your SolarWinds database.
  5. Double-click the Report Definitions table.
  6. Delete the default query and replace with the following (Note this will change Owner for all Reports): 
    UPDATE ReportDefinitions
    SET Owner = '{new user}'
    WHERE Owner = '{old user}'
  7. Click Execute Query. 
    • For a list of accounts, check the Accounts table.
    • Pay attention to letter casing in account names.
  8. To change individual Report Owners, find selected report, click Enable Table Editing, click the Owner Field and change it to the desire Owner.
  9. After updating the DB, restart Orion Services.


Last modified
23:27, 22 Jun 2016