Submit a ticketCall us

Have You Auto Renewed? If not, you're missing out.
The SolarWinds Renewal Program comes with a host of benefits including the most recent product updates, 24/7 technical support, virtual instructor-led training and more. Experience all of this with the convenience of Auto Renewal, and never worry about missing any of these great benefits. Learn More.

Home > Success Center > Archive > 2018Jan2 - Deletes > 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 Kevin.Swinson on Jan 02, 2018

Views: 777 Votes: 0 Revisions: 5

Overview

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.

Environment

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

Cause 

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.

Resolution

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

Tags

Classifications

Public